I have a series of calculations that are stored as containers. They all say: If ( field > 10 ; Image On ; Image Off ). I need a function that can "Count" how many Image On's there are on each record. I'm not an expert with the Count function, if that's the best one to use, and the examples of it's use online seem to be sparse...

Any ideas? Thanks.

Unfortunately, Filemaker has no CountIf() function, and it counts anything that isn't empty. Try defining another calculation field (result is number) =

field > 10

then use a summary field to total (i.e. sum) the results.

I need a function that can "Count" how many Image On's there are on each record.

It isn't clear if you want to count many images of a single record...

If it is so, you could use something like:

( field > 10 ) + ( field2 > 10 ) + ( fieldN > 10 )

It isn't clear if you want to count many images of a single record...

Ah. That's a good point. Hopefully, that's not the case - because that would be a structural problem.

I don't know if it's the best way, but I just asked did duplicate calculations, one stored as a container to show the image, and the other as a number, and added them up as Comment suggested. Thanks for the help.