Takes a list item or time period as parameter and returns the name of the list item or time period as text.
Syntax
NAME(x)
where:
- x: list-formatted, time period-formatted line item, or a hard-coded parameter makes reference to the time scale to be converted.
Format
| Input Format | Output Format |
|---|---|
|
x: list-formatted, time period-formatted line item, or a hard-coded parameter makes reference to the timescale |
Text: Name of the list item or time period |
Arguments
The function uses the following arguments:
- x: Date: Hard-coded date, date variable, or line item
- x: Text: Text-formatted line item
Constraints
The function has no constraints.
Excel equivalent
Example
In this example, a simple two-dimensional Product Margins module has the Products list as columns and line items as rows. Product Name is a text-formatted line item and uses a formula that nests the ITEM function to return the relevant item in the Products list according to the grid location. NAME then converts the list item returned by ITEM to text:
Example with Time
The following examples of using NAME with time parameters uses a two-dimensional module with versions on columns and line items on rows:
- Feb 15 = NAME(Month Period) where the Month Period source line item is time period-formatted for months and Feb 15 is selected and Period Name Month result is text-formatted:
- Q1 FY15 = NAME(TIME.'Q1 FY15') where the result is text-formatted:
