Jan 28, 2017 at 01:03 PM|55 Views | Last edit Jan 29, 2017 at 10:38 AM 2 rev.
Hi Guys,
We have a weird issue and I would like to know possible places for incorrect logic. My script in default logic says: if the changed Cost element is B, then look for rate in Cost element C. If there is no rate for CE C, use the value in CE A for CE A.
In my input layout I am only changing CE A. What is weird is it is allowing me to change for all the months except for 1st month. For another cost center it is not allowing me to change anything. As there is no difference in any dimension including cost element except for hierarchies they belong to I am breaking my head over what can go wrong.
*IS CE B
*BEGIN *REC(EXPRESSION=(([KEYFIGURE_TYPE].[RATE],[COSTELMNT].[CE C])>0? %VALUE%*((([KEYFIGURE_TYPE].[RATE],[COSTELMNT].[CE B])* ([KEYFIGURE_TYPE].[RATE],[COSTELMNT].[CE C]))+ ([KEYFIGURE_TYPE].[RATE],[COSTELMNT].[CE C])): ([COSTELMNT].[CE A])),COSTELMNT= CE A)
I know I cannot get answers on these but I am looking at the approach I am taking to solve this puzzle. Anyone has a better approach to solve this?
Add comment