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: