Bad Totals - Sub-Sumary not working

[mikemccabe29]

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…

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  
 

[bcooney]

Can you upload a sample file?

 

On which table occurrence are you basing the report layout? I'm trying to understand why the flag field "High, Medium or Low" cannot be stored.

 

Also, what is your "real" calculation for the flag field, because If ( GIFT = "1-99" ; 1; "0" ) can't be the calc you're using.

 

Where is the summary field (count of the flag field)? Then sub-summary by the flag field.

[Vaughan]

Unstored fields can be used with summaries.

 

"I am setting a High, Medium or Low flag for each gift.  

If ( GIFT = "1-99" ; 1; "0" )"

 

 

I assume you have three fields, one for High, Medium and Low flags?

 

Not the right way. You should have 1 field that displays High, Medium or Low as a value depending on the amount of the gift. Then use this field for the summary.