Sum help is needed (excuse the pun)
I have read previous sum threads before but they don't seem to address my problem. I hope you can help.
The table ProposedBudget has a field called Category.
In the cTotalAdministration field in the ProposedBudget table, I would like to put in a calculation that gives me the sum from all records that have "Administration" in the Category field.
Set up a calculation field such as:
If ( Category = "Administration" ; BudgetAmountField )
Then add a summary field that computes the total of this calculation field.
Use ExecuteSQL: FMP 12 Tip: Summary Recaps (Portal Subtotals)
Or use one of the methods described here: Sum_Calculation based on condition