Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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)

Tags:
replied

use this.

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question