Circular Reference with CUMULATE

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

Hi All,

 

I am trying to solve an excel model in Anaplan where my current value is a calculation of the cumulative of previous values. The calculation works fine in excel but I am unable to break this down in Anaplan. I am adding the screenshot for the logic of this model below. Any help or suggestions would be helpful.

 

shrey_meher_0-1610035870209.png

 

Tagged:

Comments

  • shrey
    shrey Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor
    Hi Nathan,

    Thank you for your response.
    I tried using PREVIOUS() while calculating total rent. However, with CUMULATE() variable rent, it is not working as expected. I have also tried other combinations of formulas using PREVIOUS() and CUMULATE() but it did not work for me.
  • shrey
    shrey Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor
    Hi Chris,

    Thank you for your response.

    I tried to do as per your suggestions as shown below. My understanding is that with CUMULATE() & PREVIOUS() variable rent, it is referring back to the same line item and is unable to break circular reference.

    if cumulate(Revenue) *0.05> cumulate(Previous Variable Rent)+cumulate(Fixed Rent) then cumulate(Revenue) *0.05- (cumulate(Previous Variable Rent)+cumulate(Fixed Rent)) else 0

Categories