This content has been marked as final.
Show 1 reply

1. Re: Rolling Calculation in Linear Model using Calculated Field
swaroop.gantela Jun 29, 2016 4:19 PM (in response to Wan Theng)Wan,
Yes, I think you can use Previous_Value in this way:
IF NOT(ISNULL(SUM([C]))) THEN SUM([Coeff A])*SUM([A])+SUM([Coeff B])*SUM([B])+SUM([Coeff C])*SUM([C])
ELSE SUM([Coeff A])*SUM([A])+SUM([Coeff B])*SUM([B])+SUM([Coeff C])*PREVIOUS_VALUE(0)
END
The "Compute using" can be Table (Down).
Here is a somewhat similar thread:

210066linear.twbx 11.7 KB
