1. Calculation functions
  2. All functions
  3. Logical functions
  4. ISANCESTOR

The ISANCESTOR function takes two list or time period values. It returns a Boolean value of TRUE if the first is the ancestor of the second. An item is the ancestor of another if it is at a higher level of a list hierarchy.

Syntax

ISANCESTOR(Ancestor, Child)

Arguments

ArgumentData typeDescription
AncestorList, time periodThe value to test whether is an ancestor of the Child argument.
DescendentList, time periodThe value to test whether is a descendent of the Ancestor argument.

The ISANCESTOR function returns Boolean result.

Related Anaplan functions

LOOKUP

Examples

List example

In this example, a module has the Organization list on columns and line items on rows.

The Organization list is a hierarchical list with a top level of company. Within this list, regions are the parents of countries, and countries are the parents of cities.

The first line item, City, uses the ITEM function to return each location within the Organization list. Three further line items use the ISANCESTOR function to check whether these cities are part of the UK, France, or the EMEA region respectively.


LondonBirminghamParisLyonNew YorkLos Angeles
CityLondonBirminghamParisLyonNew YorkLos Angeles

Part of UK?

ISANCESTOR(Organization.UK, City)





Part of France?

ISANCESTOR(Organization.France, City)





Part of EMEA?

ISANCESTOR(Organization.EMEA, City)



Time period example

In this example, the Dates list is on columns, and line items on rows. The Chosen Month and Chosen Quarter line items have the time period data type. The Quarter is Ancestor? has the Boolean data type and uses the ISANCESTOR function. This returns a Boolean value of TRUE if the value of Chosen Quarter is an ancestor of Chosen Month.

The final line item, Within Q3?, uses a direct reference to the time period of Q3 FY22 and checks whether it's the ancestor of Chosen Month.


Key DatesExpiry Dates
Chosen MonthFeb 2022Jul 2022
Chosen QuarterQ1 FY22Q1 FY22

Quarter is Ancestor?

ISANCESTOR(Chosen Quarter, Chosen Month)


Chosen Month Within Q3 FY22?

ISANCESTOR(Time.'Q3 FY22', Chosen Month)


Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.