How to pick up the balance from a previous month

Hi,

We are trying to pick up a Line Item Balance from the previous end of the month. For example, for the month of Feb, need to see the ending balance that is at the end of January.

Accepted answers

AntonMineev

You are welcome. if my answer helped you, please mark it as a solution.

All comments

AntonMineev

Hi @neg177!

Do you use custom time or no?

Classic solution with native time:

1. You calculate CB on month (OB + Movements).

2. You calculate Opening Balance use PREVIOUS(CB) formula.

This formula take amount from previous month from needed LI.

neg177

ok, Thank you

AntonMineev

You are welcome. if my answer helped you, please mark it as a solution.

Quick Links

Can you help?

Unanswered questions

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…