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 |