> For the complete documentation index, see [llms.txt](https://docs.tomat.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/varianceif.md).

# VarianceIf

Gets the variance of non-empty values in the column filtered by the condition

```mathematica
VarianceIf(column1, column2 == 22) → 2
VarianceIf(column1, IsOdd(column2)) → 360.91
```

#### Inputs

`VarianceIf(column, [condition])`

* `column` - A column to calculate the variance for
* `[condition]` - **\[optional]** - Condition to filter values in the column