User Defined Measure Unexpected Behavior — 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

User Defined Measure Unexpected Behavior

Hi experts - hoping I can get some pointers on where to look to understand this behavior and fix the issue.

We have a requirement to create a new measure called 'GVI DP_Ftrend_Vol'. This measure should behave as follows:

If there is no 'Shipments Forecast', then pick 'Shipments History' else pick 'GVI Consensus Forecast'. To achieve this, we have built the expression logic as follows:

If(NVL(Shipments Forecast,0) = 0, Shipments History, GVI Consensus Forecast)

What we are observing is that this is working well when 'Shipments History' needs to be the value picked, but when 'GVI Consensus Forecast' should feed this measure, we are noticing variation on about 60 items for only a few months.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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