FileMaker Pro 11
I have a membership list that has ACTIVE and INACTIVE members. I want two calculation fields in this table - one field for total ACTIVE count and one field for total INACTIVE count. Apparrantly, Get (FoundCount) only works with the current Found Set which can change. Is it possible to have both or perhaps there is another calculation that I can use.
Thanks for any help.