SUM IF - need to add number only if they are negative

[#1]

I am working on the table "Software Maintenance Inflation (Balance)" See attached qvw.

We want to show how much is left in our budget item we call Inflation.  I need to subtract from the BLI inflation all the (budget_amt - PO_Amt) that are negative.  In simple math:

Column 1

total of BLI = INFL

Column 2

-sum(budget_amt - PO_Amt)) ---only where Budget_Amt - PO_Amt is negative

Column 3

Balance = Column 1 - Column 2

[lironbaram · Accepted solution]

HI

have a look at the attach example

[#3]

Thank you , yes.  That worked.  I just need to add Col 1 with Col 2, as Col 2 is negative.