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

Takes a list item or time period as a parameter and returns the parent of the list or parent time period.

The function is used on nested list hierarchies where you want to return the parents of items belonging to a lower-level list.

If you use PARENT against time period items, the time period returned is determined by the time period granularity of the result.

Syntax

PARENT(x)

where:

  • x: list-formatted or time period-formatted line item.
PARENT(TIME.'Feb 15')

where:

  • a hard-coded parameter makes reference to the time scale.

Format

Input Format Output Format

x: List item, time period

Matches the data format used by argument x

Arguments

The function uses the following arguments:

  • x: Line item: List-formatted, or time period-formatted

Constraints

The function has the following constraints:

  • Source and Result must be list or time period-formatted.
  • If used with time period, the time period returned is determined by the time period granularity of the result.
  • You don't have to nest the PARENT function within a formula to return the year as parent result for a week or month time period parameter — just make sure the result line item is time period-formatted for years.

Excel equivalent

  • No Excel equivalent

Back to Top

Example

List

In this list example, we have a two-dimensional module with line items on columns and the Outlets list on rows. The Parent Territory line item formula uses the ITEM function to return the Outlets list item for the row and then PARENT returns the parent of that list item in the hierarchy:

PARENT(ITEM(Outlets))

Time

For these time examples, we have a simple two-dimensional module with Versions on columns and line items on rows:

Q2 FY15 = PARENT(Month Period) 
  • where the Month Period line item is time period-formatted for months and May 15 is selected and Parent Quarter result is time period-formatted for quarters:
FY15 = PARENT(Month Period) 
  • where the Month Period line item is time period-formatted for months and May 15 is selected and Parent Year result is time period-formatted for years:
H1 FY15 = PARENT(TIME.'Apr 15') 
  • where Parent Period Absolute result is time period-formatted for half-years:

Back to Top

Similar functions