Skip to main content
Solved

How to solve Circular dependency

  • July 31, 2023
  • 1 reply
  • 338 views

abhilashsawla
Forum|alt.badge.img+7

Hi All

I need to calculate Level & Trend column from actual and formula is to calculate is:

Level  Lt = α yt  +  (1 - α) (Lt-1 + Tt-1)
Trend Tt = β (Lt - Lt-1) + (1 - β) (Tt-1)

Here y= Actual,  α & β=0.5 , L1=(y1+y2+y3)/3 and

T1 = ( (y2 - y1) + (y4 - y3) ) ÷ 2

I tried to solve it by previous function & select modifier but facing circular dependency during calculation. Please help me to solve it.

Sales (Actual Dt) Level (Lt) Trend(Tt)
587 605 -145
423 442 -154
805 547 -25
680 601 15
813 715 65
766 773 62

Best answer by Benoit

Hi Abhilash,

Would you please be able to share your pigment formulas for each metric and specify with one return the error?

I believe we can try a different approach similar to what I’ve described here

https://community.pigment.com/questions-conversations-40/asset-amortisation-schedule-1453?postid=3184#post3184

Thank you

 

View original
Did this topic help you find an answer to your question?

Benoit
Community Manager
Forum|alt.badge.img+13
  • Community Manager
  • August 17, 2023

Hi Abhilash,

Would you please be able to share your pigment formulas for each metric and specify with one return the error?

I believe we can try a different approach similar to what I’ve described here

https://community.pigment.com/questions-conversations-40/asset-amortisation-schedule-1453?postid=3184#post3184

Thank you

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings