Ending Balance Roll Forward to the Current Period
I hope you are all doing well.
I need some help on my calculation.
Issue is, I need my ending balance of the prior period to be the beginning balance of the current period.
The thing is, these movements (beginning +/- movements = ending balance) are all members of the same list.
It just does not come forward.
The formula goes like this:
IF ITEM(PPE Cost Movements) = PPE Cost Movements.Beginning Balance
THEN PREVIOUS(Line Item in Issue[SELECT: PPE Cost Movements.Ending Balance]) ELSE 0
It should take the 284M as the beginning for Jan 20 and not the loaded 295M anymore.