Identifiers

Some of the the identifiers available in Inforiver Matrix 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
CURRENT_PERIOD	Calculated measure formula	Returns a reference to each period in the report
DESCENDANTS	Calculated row formula	Returns all the children's values (till the leaf level) as an array
FORECAST.CLOSED_END	Calculated measure formula	Returns the end date of closed forecasts
FORECAST.CLOSED_START	Calculated measure formula	Returns the start date of closed forecasts
FORECAST.OPEN_END	Calculated measure formula	Returns the end date of open forecasts
FORECAST.OPEN_START	Calculated measure formula	Returns the start date of open forecasts
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
LOGGEDIN_EMAIL	On change formula	Returns the email ID of the user making data input updates
LOGGEDIN_NAME	On change formula	Returns the name of the user making data input updates
MATCH	Calculated column formula	Checks whether the specified value is an exact match
MAXDATE	Calculated measure formula	Returns the latest date available in a report.
MEMBERS	Calculated row formula	Returns all the immediate children's values as an array
MINDATE	Calculated measure formula	Returns the earliest date available in a report.
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