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