Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can I do because VAR% in the attached example the column on the line agent A4 appears "-100.00"
This agent A4 not have sales in year 2015 and so the VAR column can not do with a division by 0.
(1 - sum (Year2014) / sum (Year2015)) * 100
For the line A4 is sum (Year2015) = 0
thank All
Try this:
Alt((1 - (Sum ({<Year={"$(=(max(Year)-1))"}>} Sales) /
Sum ({<Year={"$(=(max(Year)-0))"}>} Sales)) ) * 100, -100)
Try
(1 - alt((Sum ({<Year={"$(=(max(Year)-1))"}>} Sales) /
Sum ({<Year={"$(=(max(Year)-0))"}>} Sales)) ,2)) * 100