Forum Discussion
Solved
How to modify Vari % expression to return +ve % ?
Hi All
My expression is working fine :-
Vari % = if(isblank( divide([SUM_YTD]-[SUM_LYTD],[SUM_LYTD])),1, divide([SUM_YTD]-[SUM_LYTD],[SUM_LYTD]))
But for below situation , See image below , how to modify above expression , when LYTD -ve and YTD +ve it will return +ve %
admin11 , You can try like.
divide([SUM_YTD]-[SUM_LYTD],abs([SUM_LYTD]),1)
1 Reply
admin11 , You can try like.
divide([SUM_YTD]-[SUM_LYTD],abs([SUM_LYTD]),1)