OBIEE / OTBI Pivot Table Calculated % Variance
Summary: Need the equivalent of ABS in pivot table calculated column
Content (required):
In a pivot table presentation; -
I have a calculated column; Variance which is equal to Actual - Budget
I want another calculated column; Variance % which is ((Actual - Budget) / Budget) * 100
My problem is when the Budget is Income the % value is flipped negative, which is not how the client shows it.
In the pivot table calc columns I do not have the luxury of formulas so I cannot just / abs(Budget) to get the answer I want.
So my question is using only the basic mathematic operators + - / * is there any way to do the equivalent of turning negative to positive, without also turning positive to negative?