Custom Calculation not working and giving incorrect result
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?
Tagged:
0