Abs% Error Expression Not Returning Value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Abs% Error Expression Not Returning Value

Summary:

We created a custom measure to calculate the Abs% Error, but we cannot get it to return a value.

The expression uses Booking History, and Booking Forecast to derive the %. This issue is when there is no Booking history, the calculation fails as its dividing by zero and leaves a blank. I tried to include an IF statement to replace Null bookings with 100, otherwise continue with Abs(Booking-Forecast)/Bookings

I've included the expression below, but it still leaves a blank, instead of 100?

Content (please ensure you mask any confidential information):

If (Bookings History = null,100,(safe_division(abs(nvl(Bookings History,0) - nvl(Bookings Forecast,0)),Bookings History,0)*100))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!