1. Calculation functions
  2. All Functions
  3. Miscellaneous Functions
  4. NAME

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

Back to Top

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:

Back to Top

Similar functions