Solved

How to solve Circular dependency

  • 31 July 2023
  • 1 reply
  • 194 views

Userlevel 4
Badge +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
icon

Best answer by Benoit 17 August 2023, 15:56

View original

1 reply

Userlevel 6
Badge +12

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

Thank you

 

Reply