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

[Former Member]

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,

Vince

[Former Member]

I have found out the solution.

Xcelsius Menu Bar > File > Preference > Excel Options

Tick on "Ignore Excel Formula Errors".

And its done!

[Former Member]

No it does not works.

Please provide some other way if any.

[former_member182541]

Use this!