Skip to main content

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

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