MLINREG ( value_expression, width, sort_expression [ ASC | DESC ] )
Syntax Elements
-
value_expression
- The expression cannot contain any ordered analytical or aggregate functions.
-
width
- The number of previous rows to be used in the computation.
- The value is always a positive integer literal.
- The maximum is 4096.
-
sort_expression
- A column expression that defines the independent variable for calculating the linear regression.
- For example, MLINREG(Sales, 6, Fiscal_Year_Month ASC), where Sales is the value_expression, 6 is the width, and Fiscal_Year_Month ASC is the sort_expression.
- The data type of the column reference must be numeric or a data type that Vantage can successfully convert implicitly to numeric.
- ASC
- Ascending sort order.
- DESC
- Descending sort order.