AnsweredAssumed Answered

Sum total based on value in corresponding text field

Question asked by littlejon on Feb 5, 2009
Latest reply on Feb 11, 2009 by Orlando

Title

Sum total based on value in corresponding text field

Post

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. 


Outcomes