AnsweredAssumed Answered

Can't get proper totals in sub-summary

Question asked by mikemccabe29 on Feb 7, 2013
Latest reply on Feb 8, 2013 by philmodjunk

Title

Can't get proper totals in sub-summary

Post

      

     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 

RawLayout.png

Outcomes