Get(foundCount) not working properly

Filemaker 19 on windows 10.
Pls see sample file attached, the get(foundcount) function is not returning the right value in a global ( or even a regular field) - but shows correctly in the data viewer.
FoundCount fieldis a calc = get(foundcount).

Do you get the same incorrect results.
Maybe missing something very basic.

thanks
Kevin

RecordTest.fmp12 (216 KB)

In your 'FoundCount' field options, have you set the storage option to 'unstored (re-calculate when needed)'? It would need that...

1 Like

Ah - just noticed you posted a sample file.. I changed the FoundCount field to 'unstored' and it works ok...

4 Likes