Need to sum the difference of two summary columns

I can sum the two summary columns in the reports

However I need to omit from the total the data from the column when the other column is empty

In Table “Basic Summary” 

Fuel Amount: SUM(SELECT([Expenses][AMOUNT], [EXPENSE] = "Fuel"))

Fuel Discount: SUM(SELECT(Expenses[Fuel Discount], AND([DATE] >= [_THISROW].[start date], [DATE] <= [_THISROW].[end date])))

[Fuel Amount]-[Fuel Discount]

I need to sum this but exclude the data from “Fuel amount” where the “Fuel Discount is missing

Basic Summary TableBasic Summary TableExpenses TableExpenses Table

Solved Solved
0 3 102
1 ACCEPTED SOLUTION

You can try this:

IF([Fuel Discount] = 0, 0, [Fuel Amount] - [Fuel Discount])

View solution in original post

3 REPLIES 3
Top Labels in this Space