CONSOLIDATEMEDIAN ^v2.7.26

Returns the median value of all child values for a given consolidation intersection. This function only works at a consolidated level.

CONSOLIDATEMEDIAN(dimension)

Parameters

• dimension - The dimension used to get the median of children.

Examples

IF(ISLEAF(), CONTINUE, CONSOLIDATEMEDIAN("Time"))

Note: If this is calculating a N-Level value it will return said value. If this is calculating a consolidation on the Time dimension it will return the median of direct children values.