GETLEVEL
This function, in the data cell of a hyperblock, returns the level of each element that is displayed in the hyperblock.
Syntax
GETLEVEL(reference)Example
A hyperblock in cells C7:D7 displays a hierarchical list. This function, in D7, returns the level number of each element in the list:
=GETLEVEL(C7)
To return a level number attribute from the database, use an ROA formula.
Example
=ROA("AdventureWorks","Direct Sales","[product]","Level_Number",B3)The level of an element displayed in a hyperblock may not be the same
as its level in the database.
Note: Levels returned by the GETLEVEL function are numbered from 1
upwards. Levels returned by the ROA function are numbered from 0 upwards.