Custom calculation Conditional check
SummaryNeed help on building custom calculation logic
I need help in building one single custom calculation to derive driver data for 4 scenarios using Actuals. I need previous year value to use within my custom calculation but as member functions cannot be used in custom calculation and no variable concept in PCMCS, I am trying Case and IIF( ) condition but nothing is working out.
My requirement details are as follows:
We have 3 Forecast scenarios (3+9, 6+6,9+3) and AOP. To derive the driver data for these 4 scenarios, we need to average out the Actuals driver data that gets loaded through ERP