View Single Post
 
Old 03-17-2021, 01:05 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by Marcia View Post
Arvil may I ask about the function of the extra comma after tAnnex?
I assume the question is about formula in SALARY column of Table tAnnex.

tAnnex in formula returns datarange of Table tAnnex, i.e. a range A2 : D5 in example file. NB! This range is 2-dimensional, i.e. in general it contains rows and columns.
For 2-dimensional ranges/array:
INDEX(DataRange,RowNo,ColumnNo), returns a value from single cell;
INDEX(RowNo,), returns a single row from datarange;
INDEX(,RowNo), returns a single column from datarange;

As follows, 'INDEX(tAnnex,,[@[SALARY STEP]]+1)' returns a datarange column ([@[SALARY STEP]]+1 from tAnnex, i.e. when SALARY STEP in tSalaries is 1, the column Step1 of tAnnex is returned, when SALARY STEP is 2, the column Step2 is returned, etc.
Reply With Quote