Divide by zero error in Universe (BW Universe in IDT)

[Former Member]

How to handle Divide by zero error in universe, when data source is BW.

I tried to create a CASE statement but its not working

CASE WHEN @Select(Report Objects\Forecast) = 0 THEN 0 ELSE ((@Select(Report Objects\Orders)/@Select(Report Objects\Forecast))*100) END

Getting following error when tried case statement

also tried ifElse condition

ifElse(@Select(Report Objects\Forecast) = 0, 0, ((@Select(Report Objects\Orders)/@Select(Report Objects\Forecast))*100))

but still getting the error.

Is there any other function to use?

Environment: Information Design Tool 4.1

Developing Design Studio Application (Webi not available to handle this)

[amitrathi239 · Accepted solution]

use this.

CASE WHEN @Select(Report Objects\Forecast) = 0 THEN toDecimal(0) ELSE ((@Select(Report Objects\Orders)/@Select(Report Objects\Forecast))*100) END

[Former Member · Accepted solution]

Thanks Amit. It worked like a charm.