Custom calculation Conditional check

Summary

Need help on building custom calculation logic

Content

Hi All,

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