AnsweredAssumed Answered

Conditional sum

Question asked by WPSP on Mar 12, 2010
Latest reply on Mar 12, 2010 by mrvodka


Conditional sum


I have two tables: Expenses and Budget_Overview.


Table: Expenses

Fields: Trade_Show_ID, Trade_Show, Category, Date, Amount


Table: Budget_Overview

Fields: Trade_Show_ID, Airfare_Actual, Hotel_Actual....etc


Trade_Show_ID are related.


So the Expense table will have one expense is one record. In Each expense there is a specific category and trade show id. I need to sum up all the amounts that fall within a given category within a trade show id.


I have a field in the Budget_overview table called Airfare_actual. I have this set to a calculation field. This is what I have: Airfare_Actual=if ( Expenses::Categoy = "Airfare" ; Sum (Expenses::Amount))


It sums the amount but has no regard for what the category is set to. It does only sum the amounts for the related trade show id though.


Any Help would be great.