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
edited Dec 14, 2020 6:43AM in Profitability and Cost Management 2 comments


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.


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