Function: Count()

Discussion created by gcatnine on May 30, 2016
Latest reply on May 31, 2016 by TSGal

FMPro Adv 14 and 15

Windows 10

all with latest updates


The function Count() returns wrong results when used in a script counting repeating fields and non repeating fields.


I found different results using the function Count() in a calculated field and in a script.

I replicated the example that is present in the manual of the function.

The calculated field has the correct results, where the calculation in the script add 1 to the results in all repetition except the first one if there is a non empty non repeating field in the calculation, i.e:

Count(Table::f1;Table:F2;Table;F3) where F2 is a non repeating field.

If the non repeating field is empty, the result is correct.

See the attached example.