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 not working and giving incorrect result — 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 not working and giving incorrect result

Received Response
20
Views
2
Comments
edited Dec 14, 2020 6:43AM in Profitability and Cost Management 2 comments

Content

Hi all,

My Custom Calculation is not working and giving incorrect result.

My formula will work if I will use in this syntax-

 [Allocation Per Day]:=(([Drilling Allocated Amount],[Rule])+([No Driver],[Rule]))/365;

But in case of "365" if I will store this 365 in other Driver dimension i.e. "Rig1 Operating Days" instead of using 365 and change the formula accordingly then it will not work-

 [Allocation Per Day]:=(([Drilling Allocated Amount],[Rule])+([No Driver],[Rule]))/([Rig1 Operating Days],[Rule]);

Instead of "365", I am taking "([Rig1 Operating Days],[Rule])" but it is not working.

Can anyone help me out with this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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