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

Reply via email to