CONSOLIDATESTANDARDDEVIATIONNOZEROS ^v2.7.26 ​

Returns the standard deviation of all child values excluding 0 values for a given consolidation intersection. This function only works at a consolidated level.

CONSOLIDATESTANDARDDEVIATIONNOZEROS(dimension)

CONSOLIDATESTANDARDDEVIATIONNOZEROS(dimension)

Parameters ​

• dimension - The dimension used to get the standard deviation of children.

Examples ​

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

IF(ISLEAF(), CONTINUE, CONSOLIDATESTANDARDDEVIATIONNOZEROS("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 standard deviation of direct children values excluding zeros.