---
url: /cube-functions/consolidatestandarddeviationnozeros.md
description: >-
  Returns the standard deviation of all child values excluding 0 values for a
  given consolidation intersection.
---

# CONSOLIDATESTANDARDDEVIATIONNOZEROS 

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

```js
CONSOLIDATESTANDARDDEVIATIONNOZEROS(dimension)
```

#### Parameters

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

#### Overloads

**Card Overload:**
This overload can be used in cards to point to a specific cube location.

* `Cube` - Cube name to query.
* `Location` - Location within cube.
* `Dimension` - The dimension used to get the standard deviation of children.

#### Examples

```js
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.