Referencing same line item of prev row

Hi,

I am facing issue in trying to reference the same item of prev row. For example,

This is the Excel formula for a line item ‘Calendar Month’ :

IF Calendar month of prev row = 12 THEN 1 ELSE Calendar month of prev row + 1

Has anyone faced similar issue? The Else part of the formula gives circular reference.

Accepted answers

Could you please describe a little bit more what you are trying to achive with this formula?

I have Month No. as my row, trying to apply formula for Calendar month line item

PFB the Screenshot :

You can use CUMULATE formula for this. Cumulate by Month No. list via Count. https://help.anaplan.com/1173a903-81bb-4838-a4d0-1c9f9c739aa3-CUMULATE
CUMULATE(1,[boolean to recet counter],[month no. list])

boolean to reset counter can be based on Start month = Val_Date

As per my understanding , use the cumulate function - the Boolean line item used to reset the start month

Cumulate(Month No, boolean)
find the attachment for your reference

Thank you. I was able to resolve the functions for Month/Year related line items using Cumulative.

But I have similar issues with other line items too, where we cannot use Cumulate() or Mod().

For Example:

These items are dependent on each other, hence giving circular reference

Any workaround for this?

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…