LEVELSBETWEEN ​

Returns the number of steps from the Ancestor specified to the Descendant specified.

LEVELSBETWEEN(dimension, ancestor, descendant)

LEVELSBETWEEN(dimension, ancestor, descendant)

Parameters ​

• dimension - The dimension to source the sequence from.
• ancestor - The ancestor to count the amount of steps from.
• descendant - The descendant to count the amount of steps to.

Examples ​

LEVELSBETWEEN("Account", "EBITDA", ELEMENT("Account"))

LEVELSBETWEEN("Account", "EBITDA", ELEMENT("Account"))