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.
You are welcome. if my answer helped you, please mark it as a solution.
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.
ok, Thank you
I am trying upload data from a CSV with date. For size reasons, I don't want to dimension the module by date but bring it in as a line item formatted as date. The problem is that person that will be doing the upload is in Italy, and their date format is different. When she does the upload, the date gets messed up…
Hi, when I am assigning the account to the territory I am always facing error as below and account never get assigned to the territory , what could be the reason ? When I use same method for unassign it works .
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…