AnsweredAssumed Answered

Report sub total calculation

Question asked by dg3321 on Jan 25, 2011
Latest reply on Jan 25, 2011 by dg3321


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.