#Overflow error due to division with 1.#INF

[former_member221196]

Hi All,

I am working with BO 4.0 i want to divide two measure objects, where as A/B , the B 's  one of the values is 1.#INF so i am getting

#overflow error so i want to change 1.#INF(measure) to value 1. how can i achive this.

Thanks

[peter_ostlaender]

Use NOERRO() or NODIV() methods in BEx or use this formula in WEBI

=If(FormatNumber([KF];"#,#")="1.#INF") Then 0 Else [KF]

Thanks