Identifiers

All the identifiers available in Inforiver are showcased with examples in the below .pbix file.

6MB

Inforiver Formula - Identifiers.pbix

IDENTIFIER	USAGE	DESCRIPTION
CLOSEDPERIOD	Calculated measure formula	Checks if the forecast measures belong to the closed or open period
COLUMN.DATE	Calculated measure formula	Returns the date in a measure's header/title
COLUMN.PARENT	Calculated column measure	Returns the column's immediate parent in a column hierarchy
COLUMNS	Calculated measure formula	Returns a reference to a specific column in the report
DESCENDANTS	Calculated row formula	Returns all the children's values (till the leaf level) as an array
GROUP_INDEX	Calculated row/column formula	Returns the position of a column
HAS	Calculated column formula	Checks if the specified value is part of the list
HAS_ALL	Calculated column formula	Checks if all the specified values are part of the list
HAS_SOME	Calculated column formula	Checks if one or more of the specified values are part of the list
LEVEL	Calculated column formula	Returns the row level in the hierarchy
MATCH	Calculated column formula	Checks whether the specified value is an exact match
MEMBERS	Calculated row formula	Returns all the immediate children's values as an array
RELATIVE	Calculated column formula	Changes the absolute cell/column reference to a relative reference
RELATIVE_COLUMN	Calculated row formula	Returns the value of the column relative to the current column
ROW.LABEL	Calculated row formula	Returns field values used to populate rows in the report
ROW.PARENT	Calculated row formula	Returns a reference to the parent levels in the hierarchy