Set Analysis: divide by zero

[#1]

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

[sunny_talwar]

Try this:

Alt((1 - (Sum ({<Year={"$(=(max(Year)-1))"}>} Sales) /

   Sum ({<Year={"$(=(max(Year)-0))"}>} Sales))  ) * 100, -100)

[swuehl]

Try

(1 - alt((Sum ({<Year={"$(=(max(Year)-1))"}>} Sales) /

   Sum ({<Year={"$(=(max(Year)-0))"}>} Sales))  ,2)) * 100