Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
have a look at the attach example
Thank you , yes. That worked. I just need to add Col 1 with Col 2, as Col 2 is negative.