Relative x and y references

TARGIT author

January 15, 2021 12:58

E.g. -2, -1, 0, 1, 2 etc. – zero refers to current column/row, negative integers refer to previous columns/rows and positive integers refer to subsequent columns/rows.
E.g. in a calculation of difference between 2 columns the row reference will be 0 – meaning the calculation must be done in the current row. Example: sum(d-1, 0, m1) – sum(d-2, 0, m1)
E.g. in a calculation of totals per column the column reference will be 0 – meaning the calculation must be done in the current column. Example: sum(0, all, m1).