Skip to Content
avatar image
Former Member

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

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)

1.PNG (14.6 kB)
2.png (30.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 25, 2016 at 07:38 PM

    use this.

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

    Add comment
    10|10000 characters needed characters exceeded