Referencing same line item of prev row

NivyaR
New Contributor

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.

 

7 REPLIES 7
KirillKuznetsov
Certified Master Anaplanner

Re: Referencing same line item of prev row

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

Re: Referencing same line item of prev row

NivyaR_0-1629106244346.png

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

NivyaR
New Contributor

Re: Referencing same line item of prev row

PFB the Screenshot :

 

NivyaR_0-1629106429511.png

 

KirillKuznetsov
Certified Master Anaplanner

Re: Referencing same line item of prev row

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])
KirillKuznetsov
Certified Master Anaplanner

Re: Referencing same line item of prev row

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

Re: Referencing same line item of prev row

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:

 

NivyaR_0-1629289017875.jpeg

 

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

Any workaround for this?

Javvaji45
Occasional Contributor

Re: Referencing same line item of prev row

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

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