CONSOLIDATEMEDIANNOZEROS ^v2.7.26
Returns the median value of all child values excluding empty or 0 values for a given consolidation intersection. This function only works at a consolidated level.
js
CONSOLIDATEMEDIANNOZEROS(dimension)Parameters
dimension- The dimension used to get the median of children.
Examples
js
IF(ISLEAF(), CONTINUE, CONSOLIDATEMEDIANNOZEROS("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 excluding zeros.