Yesterday my organization upgraded me Excel 2013 from 2010. In Excel 2010 I used the PowerPivot add-in. One of the measures I used was "% Change" to calculate the % change in value from one period to another. The formula I used was:

% Change:=IF([2016 Month]=0,"---",[2017 Month]/[2016 Month]-1)

I used the IF statement so that I could show a more visually appealing --- instead of an #NUM! error if the previous period was zero. Now with the upgrade to PowerPivot in Excel 2013 I get an error message from Excel saying I can't use that formula because having the second and third arguments of the IF functions with different data types is not supported.

Anyone have any ideas on how I can approach this issue?

Thanks,