Forum Discussion
Matrix data disappearing
I'm trying to create a Measure to yield the proper % Over Budget. The SOV table is consists of amounts that are classed (via a column) as "Budgeted", "Change Orders" & "Over-Budget". My first stab at...
Yes, that's fine for all situations except where there is a zero budget and a change order has created $$s in the SOV. In the image below Y-PCC0#001 should be 100%. That's why I was attempting to add an IF() condition to the measure to cover that situation.
This measure works. It returns a 1 (100% overbudget) for the odd situation:
Over Budget =
VAR LessThanBudgeted = DIVIDE([Budget]-[SOV],[Budget],0)
Return
IF(AND([SOV] > 0, [Budget] = 0), 1, LessThanBudgeted)
Just curious that the other measure caused non-related rows to vanish.
Thanks for your help.
newhopepdx
The above explanation is confusing, Can you provide a sample data and desired output.
