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.