# Identifiers

Some of the the identifiers available in Inforiver Matrix are showcased with examples in the below .pbix file.

{% file src="<https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/YqguC43ShaM7mpKhL6ir/Inforiver%20Formula%20-%20Identifiers.pbix>" %}

<table><thead><tr><th width="239">IDENTIFIER</th><th width="188">USAGE</th><th>DESCRIPTION</th><th data-hidden>EXAMPLE</th><th data-hidden>EXPLANATION</th></tr></thead><tbody><tr><td><a href="identifiers/closedperiod">CLOSEDPERIOD</a></td><td>Calculated measure formula</td><td>Checks if the forecast measures belong to the closed or open period</td><td></td><td></td></tr><tr><td><a href="identifiers/column.date">COLUMN.DATE</a></td><td>Calculated measure formula</td><td>Returns the date in a measure's header/title</td><td></td><td></td></tr><tr><td><a href="identifiers/column.parent">COLUMN.PARENT</a></td><td>Calculated column measure</td><td>Returns the column's immediate parent in a column hierarchy</td><td></td><td></td></tr><tr><td><a href="identifiers/columns">COLUMNS</a></td><td>Calculated measure formula</td><td>Returns a reference to a specific column in the report</td><td>IF(COLUMN == "AC", 5000, 6000)</td><td>On using in the row formula, returns 5000 for AC column and 6000 for other columns</td></tr><tr><td><a href="identifiers/current_period">CURRENT_PERIOD</a></td><td>Calculated measure formula</td><td>Returns a reference to each period in the report</td><td></td><td></td></tr><tr><td><a href="identifiers/descendants">DESCENDANTS</a></td><td>Calculated row formula</td><td>Returns all the children's values (till the leaf level) as an array</td><td></td><td></td></tr><tr><td><a href="identifiers/forecast.closed_end">FORECAST.CLOSED_END</a></td><td>Calculated measure formula</td><td><p></p><p>Returns the end date of closed forecasts</p></td><td></td><td></td></tr><tr><td><a href="identifiers/forecast.closed_start">FORECAST.CLOSED_START</a></td><td>Calculated measure formula</td><td>Returns the start date of closed forecasts</td><td></td><td></td></tr><tr><td><a href="identifiers/forecast.open_end">FORECAST.OPEN_END</a></td><td>Calculated measure formula</td><td>Returns the end date of open forecasts</td><td></td><td></td></tr><tr><td><a href="identifiers/forecast.open_start">FORECAST.OPEN_START</a></td><td>Calculated measure formula</td><td>Returns the start date of open forecasts</td><td></td><td></td></tr><tr><td><a href="identifiers/group-index">GROUP_INDEX</a></td><td>Calculated row/column formula</td><td>Returns the position of a column</td><td>IF(GROUP_INDEX = 1, [Sales],([Sales].RELATIVE(-1) - [Sales].RELATIVE),</td><td>With Months in column, Displays the Sales value when it is the 1st month/column(group_index =1), else returns for all other months, the variance between previous and current month</td></tr><tr><td><a href="identifiers/has">HAS</a></td><td>Calculated column formula</td><td>Checks if the specified value is part of the list</td><td></td><td></td></tr><tr><td><a href="identifiers/has_all">HAS_ALL</a></td><td>Calculated column formula</td><td>Checks if all the specified values are part of the list</td><td></td><td></td></tr><tr><td><a href="identifiers/has_some">HAS_SOME</a></td><td>Calculated column formula</td><td>Checks if one or more of the specified values are part of the list</td><td></td><td></td></tr><tr><td><a href="identifiers/level">LEVEL</a></td><td>Calculated column formula</td><td>Returns the row level in the hierarchy</td><td>IF(LEVEL = 3, 10, 5)</td><td>For each row where the heirarchy level is 3, returns 10; for other hierarchy levels, returns 5</td></tr><tr><td><a href="identifiers/loggedin_email">LOGGEDIN_EMAIL</a></td><td>On change formula</td><td>Returns the email ID of the user making data input updates</td><td></td><td></td></tr><tr><td><a href="identifiers/loggedin_name">LOGGEDIN_NAME</a></td><td>On change formula</td><td>Returns the name of the user making data input updates</td><td></td><td></td></tr><tr><td><a href="identifiers/match">MATCH</a></td><td>Calculated column formula</td><td>Checks whether the specified value is an exact match </td><td></td><td></td></tr><tr><td><a href="identifiers/maxdate">MAXDATE</a></td><td>Calculated measure formula</td><td>Returns the latest date available in a report.</td><td></td><td></td></tr><tr><td><a href="identifiers/members">MEMBERS</a></td><td>Calculated row formula</td><td>Returns all the immediate children's values as an array</td><td></td><td></td></tr><tr><td><a href="identifiers/mindate">MINDATE</a></td><td>Calculated measure formula</td><td>Returns the earliest date available in a report.</td><td></td><td></td></tr><tr><td><a href="identifiers/relative">RELATIVE</a></td><td>Calculated column formula </td><td>Changes the absolute cell/column reference to a relative reference</td><td>IFNA(([Sales].RELATIVE(-1) - [Sales].RELATIVE), [Sales].RELATIVE)</td><td>When Months in the columns, formula returns Sales of Previous month - Current Month Sales except when there is an error, then it returns the Sales of Current Month</td></tr><tr><td><a href="identifiers/relative_column">RELATIVE_COLUMN</a></td><td>Calculated row formula</td><td>Returns the value of the column relative to the current column</td><td></td><td></td></tr><tr><td><a href="identifiers/row.label">ROW.LABEL</a></td><td>Calculated row formula</td><td>Returns field values used to populate rows in the report</td><td></td><td></td></tr><tr><td><a href="identifiers/row.parent">ROW.PARENT</a></td><td>Calculated row formula</td><td>Returns a reference to the parent levels in the hierarchy</td><td>ROW.PARENT.AC + ROW.PARENT.PY</td><td>For each row it adds the value of its parent row's AC column and PY column</td></tr></tbody></table>