Forum Discussion
newhopepdx
3 years agoResolver I
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...
NaveenGandhi
3 years agoMemorable Member
Hello newhopepdx
Is there a reason why you using 1 for alternate result in divide function? Just doing this change in your first version of the measure should work.
DIVIDE( [Budget] - [SOV], [Budget], 0)
Appreciate your Kudos!
If this helps, please mark this as solution.