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

Custom Measure Calculation Error

Received Response
28
Views
3
Comments

Summary:

Created Two custom Measure:

1. Promotion Percentage

2. Adjusted Promotion Percentage Forecast

we are expecting for Customer Measure Adjusted Promotion Percentage Forecast = Promotion percentage of shipment forecast.

For ex: Promotion Percentage is 10 and shipment forecast is 110

then Adjusted promotion Percentage forecast should get 11 ( 10 % of 110 ).


Just to explain, we are using below expression on the custom measure Adjusted Promotion Percentage Forecast:

nvl((Shipments Forecast*(Promotion Percentage/100)),0)


Given the values expectation is below:

nvl((87 * (10/100),0) = 8.7


However, the expression is reflecting value as below:

nvl((87 * (10/100),0) = 0.1485


The result is way off. Could you please let us know how to correct this in the expressions. Since when we use the expression in SQL developer, correct value is reflected but when it is in the custom measure incorrect value is reflected.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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