Need to sum the difference of two summary columns

[Jack_Bates]

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 TableExpenses Table

[Markus_Malessa]

So you need [Fuel Amount]-[Fuel Discount] to evaluate to zero(0) if no data is returned in the select statement for fuel discount?

[Jack_Bates]

Yes I need to Omit the [Fuel Amount] when the [Fuel Discount]=0 for that expense ID 

[Markus_Malessa]

You can try this:

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