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

The PARENT function returns the parent item of list items and time periods.

For example, you can use PARENT to see which quarter a month belongs to.

## Syntax

`PARENT(Child value)`

## Arguments

 Argument Data type Description Child value List, time period The list or time period to return the parent of. If the item has no parent, the function returns a blank value.

The PARENT function returns a value of the same data type as the Child value argument. However, the level within the list hierarchy is different.

## Syntax example

`PARENT(Time.'Jan 21')`

This example uses the ITEM function to return the parent of January 2021. In this case it would return a result of Q1 FY21.

## Examples

### Example usage with a list

In this example, there are two lists, Outlets and its parent list Territories. The relationship of these lists is shown in the table below as they display in General Lists.

 Parent Code Outlet A1 Territory A Outlet A2 Territory A Territory A Total Outlet B1 Territory B Outlet B2 Territory B Territory B Total Total New Outlet 1 New Outlet 2

In the table below, three columns are line items and the rows are items from the Outlets list.

The Parent Territory line item has the list data type, and the Territories list is selected. The line item uses a formula that contains the PARENT and ITEM functions with the Outlets list. The ITEM function returns the list item for the Outlets list, and the PARENT function returns the parent of that list item, which is the territory.

The formula returns a blank result for the New Outlet 1 and New Outlet 2 list items as they do not have a parent.

 Allocation % Forecast Parent Territory `PARENT(ITEM(Outlets))` Outlet A1 60.0% 120,000 Territory A Outlet A2 40.0% 80,000 Territory A Territory A 100.0% 200,000 Outlet B1 75.0% 150,000 Territory B Outlet B2 25.0% 50,000 Territory B Territory B 100.0% 200,000 New Outlet 1 30.0% 60,000 New Outlet 2 70.0% 140,000

### Example usage with time periods

In the table below, the rows are line items and the columns are items from the Project Dates list.

The formula used in the Parent Quarter line item uses the PARENT function to return the parent of each month in the Month Period line item. For time periods, quarters are the parent of months, so the formula returns the quarter that the month belongs to.

 Start date Expiry date Month period Feb 21 Apr 21 Parent Quarter `PARENT(Month period)` Q1 FY21 Q2 FY21