ELEMENTHASANCESTOR

Returns true (1) if the element from the specified dimension for the cell being evaluated is a descendant of the specified potential ancestor.

js

ELEMENTHASANCESTOR(dimension, ancestor)

Parameters

dimension - The name of the dimension.
ancestor - The name of the potential ancestor.

Examples

js

ELEMENTHASANCESTOR("Time", "Default (Calendar)»2015")

Note: If the user is refreshing a workview which is only looking at 2015 - Jan the result will be 1.