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

Custom calculation Conditional check

Accepted answer
edited Jan 28, 2021 10:29AM in Profitability and Cost Management 4 comments


Need help on building custom calculation logic


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

Howdy, Stranger!

Log In

To view full details, sign in.


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