Splashing Command: Predict

The predict command (not case sensitive) calculates a new value as linear regression based on two or more given values of exactly one dimension.

Example:

predict Years:(2012:2013:2014);"All Products";Europe;Actual;Turnover;Months:("Qtr. 1")

You can use a short form if Jedox is able to guess the cell address arguments:

predict 2012:2013:2014

Important note: a prediction as linear regression is only possible if multiple elements (calculation base) of exactly one dimension are specified. Also, the final value of the multiple elements (calculation base) must not be zero.

Updated September 27, 2022