Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Custom calculation Conditional check — Cloud Customer Connect
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
19
Views
4
Comments
edited Jan 28, 2021 10:29AM in Profitability and Cost Management 4 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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