Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have YOY % calculation where I using below farmula.
if( fabs($(PY)) > 1 ,(( $(YTD) - $(PY) )/ $(PY)),null())
But it's still showing that null value in Table.
If you look at the value of %YOY column there is null value is coming for new. If i disable YOY column it is suppressing the value the row for new.
One more thing i noticed it's suppressing the value of book 5 under new but not new(as total).
It's a straight table i m using over here.
Can some body help me in this?
Thanks
Would sharing a sample a possibility?