GETLEVEL

Returns the level of an element displayed in a hyperblock.

SeeSpecifying level-specific formats of data in hyperblocks.

Syntax

GETLEVEL(Reference)

The level of an element displayed in a hyperblock may not be the same as its level in the database.

Example

If you display a hierarchical list of four levels in a hyperblock, GETLEVEL returns 1,2,3 and 4. But, if you design the list so that only the first and fourth levels are displayed in the hyperblock, GETLEVEL returns 1 and 2, not 1 and 4.

To return a level number attribute from the database, use an ROA formula.

See ROA.

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.