Referencing same line item of prev row

Options
NivyaR
NivyaR Member, ALL USERS, Certified Model Builder Posts: 5 New Contributor
in Planning & Modeling

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.

 

Tagged:

Comments

  • NivyaR
    NivyaR Member, ALL USERS, Certified Model Builder Posts: 5 New Contributor

    NivyaR_0-1629106244346.png

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

  • NivyaR
    NivyaR Member, ALL USERS, Certified Model Builder Posts: 5 New Contributor

    PFB the Screenshot :

     

    NivyaR_0-1629106429511.png

     

  • NivyaR
    NivyaR Member, ALL USERS, Certified Model Builder Posts: 5 New Contributor

    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?

Categories