RELATIVE_COLUMN
The RELATIVE_COLUMN identifier returns the value of the column relative to the current column.
Syntax
Arguments
[Row1] - Reference to a row
The argument should be a negative number.
Example
The company is planning to add one more size as Extra Large from January 2014. The expected sales for each month are going to be the same as the previous month's value for the Large size.
Relative_Column points to the previous month’s value. January value will be applied for February and so on. Since we do not have December 2013 sales, January 2014 will be blank.
If you want to display a value instead of a blank, use IF and Group index as shown below.
Note that we have used this formula in a template row, so the Extra Large row gets inserted for each category as highlighted in yellow.
Last updated
