Sum total based on value in corresponding text field
Newbie to FMP question.
I have a table with 'type' and 'amount' fields. I'd like to sum the amounts for each type.
How do I create the equivelant of: select sum(amount) from budget where type = 'income'?
I can find examples of: "Sum(Income::Budget)" but I need to add the equivalent of where criteria to a calculated field.