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.
- x: list-formatted or time period-formatted line item.
- a hard-coded parameter makes reference to the time scale.
|Input Format||Output Format|
x: List item, time period
Matches the data format used by argument x
The function uses the following arguments:
- x: Line item: List-formatted, or time period-formatted
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.
- No Excel equivalent
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:
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: