Skip to Content
0
Former Member
Jul 25, 2016 at 02:34 PM

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

425 Views

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)

Attachments

1.PNG (14.6 kB)
2.png (30.5 kB)