ValueCount with 2 criteria

[Nick Drouet]

Hi

I've got some calculation fields which use the

ValueCount( FilterValues( List( Table::Field1); "ValueToSearch")) calculation to perform an Excel-like CountIf operation, but I'd like to have a calc field which can perform a value count based on the contents of 2 fields to allow some conditionality, ie count where

Table::Field1 = "ValueToSearch" and

Table::Field2 = "AnotherValue"

How is the best method to do this?

Cheers

Nick

[comment]

AND or OR?

[cfmartinez1090]

I have been looking for the same thing for awhile.  In my case, it's AND.

[Lee Smith]

Hi cfmartinez1090 and welcome to the FM Forums,

To perform an AND find, means just putting all of the fields to be searched on one Record Request, Here is the Online help for Find Request. https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help%2Fspecify-edit-find-requests.html

To perform fore either OR, you use a new request for each of the OR searches. Something like this.

Enter Find Mode

enter your request into Field A 

New Record Request 

enter your request for Field B

Perform Find

HTH

Lee