AnsweredAssumed Answered

Conditional Sum

Question asked by donjuancarlos_1 on Dec 3, 2009
Latest reply on Dec 3, 2009 by donjuancarlos_1

Title

Conditional Sum

Post

Is there any way to do this in Filemaker?

 

Revenue and expense journal entries are posted to the same database.  Expense journal entries all have a class of 2.  Revenue Journal entries can be 1,3,4,5,6. I need to calculate the following:

 

Total Expense:  If Class = 2 then include the amount in Sum

Total Revenue: If Class <> 2 then include the amount in Sum

 

If I use a summary field, Revenue gets split up in the report

 

(btw, I am ODBCing into this database from FM10) :smileyhappy:

Outcomes