The reason I have another IIf in the denominator is because we have Previous year again in denominator and this denominator can be zero too. If I do not use this IIF again , I get " #Error as output wherever the denominator is zero.