Contributor

## Ending Balance Roll Forward to the Current Period

Hello,

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.

Thank you,

Jonathan

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Boss

## Re: Ending Balance Roll Forward to the Current Period

Try setting up a staging module where the list is not a dimension.

Use PREVIOUS(Line Item in Issue[SELECT: PPE Cost Movements.Ending Balance]) to select the ending balance of the previous month.

Reference this line item in your IF THEN ELSE.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
Moderator

## Re: Ending Balance Roll Forward to the Current Period

PREVIOUS function works on TIME only. It will not return the Previous value of any other list item.

See if this helps

1. Instead of Using Beginning balance, Ending balance and other items as a list, try creating a line item for each list item. Note: You will have to create a LOOKUP module to pull the values into line items

2. Once you have created line items for each list item write a formula in Beginning Balance line item as

Beginning Balance = If First Period of the Timescale then Source Module.Beginning Balance Else PREVIOUS(Ending Inventory

Let me know if you want to mimic it up in Anaplan.

4 REPLIES 4
Community Boss

## Re: Ending Balance Roll Forward to the Current Period

Try setting up a staging module where the list is not a dimension.

Use PREVIOUS(Line Item in Issue[SELECT: PPE Cost Movements.Ending Balance]) to select the ending balance of the previous month.

Reference this line item in your IF THEN ELSE.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
Contributor

## Re: Ending Balance Roll Forward to the Current Period

@ChrisHeathcote @Misbah thank you!

Moderator

## Re: Ending Balance Roll Forward to the Current Period

PREVIOUS function works on TIME only. It will not return the Previous value of any other list item.

See if this helps

1. Instead of Using Beginning balance, Ending balance and other items as a list, try creating a line item for each list item. Note: You will have to create a LOOKUP module to pull the values into line items

2. Once you have created line items for each list item write a formula in Beginning Balance line item as

Beginning Balance = If First Period of the Timescale then Source Module.Beginning Balance Else PREVIOUS(Ending Inventory

Let me know if you want to mimic it up in Anaplan.

Community Boss

## Re: Ending Balance Roll Forward to the Current Period

As stated above the best solution is to convert your list into a sequence of line items.
Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA