ISLEVELZERO

Returns true if the element of the specified dimension for the cell being evaluated has no children.

ISLEVELZERO(dimension, element)

Parameters

• dimension - The name of the dimension.
• element - The name of the element. (optional)

Examples

ISLEVELZERO("Time")

Note: Assuming the cell being calculated is against the time element 2018 - January (and this time dimension does not contain a week or days level) this will return true (1).

ISLEVELZERO("Time", "2018 - January")

Note: Specifically using the time element directly instead of the current context of 2018 - January (and this time dimension does not contain a week or days level) this will return true (1).