2 Replies Latest reply on Jan 25, 2011 9:46 AM by dg3321

    Report sub total calculation



      Report sub total calculation


      I am working on a report (which is pulling information from one layout), in which i am listing the name for all of the records in the layout and a particular number field.  At the end of the report i have a summary field which totals all of these numbers. 

      I am now sub-summarizing these records by category.  There are 10 specific categories that the above mentioned records could be in.

      How do i create a formula that will sum the number field by category?  Would i have to use an 'if statement'?

      I am using FMP 11.

      Thank you.