Is there any specific way to refer a Custom Measure value inside another Custom Measure expression?
I am trying to create a custom measure 'A' in Oracle Demand Management using another custom measure 'B' as a selector.
Requirement:
- If B = 1 → Demand1
- If B = 2 → Demand2
- If B = 3 → Demand3
- If B = 4 → Demand4
Expression:IF(B = 1, S1_PTM Outbound Demand, S2_12 Months Outbound Demand)
The expression validates, but the condition always evaluates as false.
Even: IF(LUS Final Forecast V2 = 1, 100, 0), the result returns 0 when the selected value is 1.
Measure ‘B’ is a Custom Measure.
Is there any specific way to reference a Custom Measure value inside another Custom Measure expression? Does aggregation/context affect this?
Tagged:
0