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)|
Best answer by BenoitView original