2 Replies Latest reply on Dec 3, 2009 3:45 PM by donjuancarlos_1

    Conditional Sum

    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: