Skip to Content
Former Member
Feb 09, 2012 at 03:03 AM

Xcelsius - is there a way to change the excel error "#DIV/0!' not to show?


Hi BI Pros,

Is there a way to make excel calculation formula that displayed "#DIV/0!" not to show in Dashboard?

Right now, what I did was changing each cell one-by-one by using "IF" statement excel formula to change the value of the calculation formula to 0.

I have tried IFERROR, but this function does not work in Xcelsius, is there any other way to change this?

Many thanks,