Can't get proper totals in sub-summary
I'm using FMP 11 Advanced:
I have a a report using a list layout in which a sub-summary part displays donations for each individual. Donations fall into different giving categories (High, Medium, Low -- for easy discussion).
If there are 50 overall gifts for this year, I'd like to tally how many "High," how many "Medium," and how many "Low," gifts there are.
I am setting a High, Medium or Low flag for each gift.
If ( GIFT = "1-99" ; 1; "0" )
NOTE: I can NOT store or index this field because it references a summary field / unstored / calc field…
(The calculation “GIFT_TIER_LOW” cannot be stored or indexed because it references a related field, a summary field, an unstored calculation field, or a field with global storage.)
Now I want to tally up those Flags, but they unstirred, so I'm not sure how to do that in the report / "on the fly."
I made a self-join relationship which I had hoped would "find" all the records which have that flag (High, Medium, Low) and then I could create a field to tally the number of records in the category by using get(found count). It doesn't work.
Any ideas? Thanks