Hello, I'm currently trying to get some subtotals to work in FMP 8.5 and I'm not sure if I need a calculation, script or something else.
I am trying to set up several calculation fields to total the number of funds we are reporting on, as well as the subtotals by active funds, by fund priority and completion, so I don't have to do a "find" each time and manually type it in. Hopefully, my layout will look like the following chart (3 columns, with totals at the bottom): Total *Pri 1 Funds Total Active *Pri 1 Funds Completed *Pri 1 Funds Total Pri 1 Funds Total Active Pri 1 Funds Completed Pri 1 Funds Total Pri 2 Funds Total Active Pri 2 Funds Completed Pri 2 Funds Total Pri 3 Funds Total Active Pri 3 Funds Completed Pri 3 Funds Total Pri 4 Funds Total Active Pri 4 Funds Completed Pri 4 Funds Total Club Funds Total Active Club Funds Completed Club Funds Total All Funds Total ALL Active Funds Total ALL Completed Funds I have the following fields and value lists: Fund Status: Active/Inactive Priority: *Pri 1, Pri I, Pri 2, Pri 3, Pri 4, Club Completion Date: [date field] (Can I use *?) Any ideas what type of calculation I would need to get subtotals totals for each? I tried Count, but it wouldn't let me specify "active" or Priority type. I figure the Grand total columns can add the fields above them, but getting those subtotal first has me at a loss. THANKS! Tamara ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Tamara N. Tsang t: 617.496.6145
