# MovingCount
The **MovingCount** function counts the number of non-null values within a column in a moving window.
### Syntax
```
MovingCount([Column], above, below)
```
Function Arguments
* **\[Column]** (required) - The column of numbers, text, or dates to count. Null values are skipped.
* **above** (required) - The first row to include, counting backward from the current row.
* **below** (optional) - The last row to include, counting forward from the current row. Defaults to 0 (current row will be the last row included).
> ### 📘
>
> When using this function without a sort enforced, there can be unexpected results. In order to ensure that the values are stable, verify that there is a sorted column within the table.
### Example
A table contains data about the amount of violations found by day during inspections in restaurants. The **MovingCount** function can be used to find the number of non-null values within different moving windows.
```
MovingCount([Violations], 4)
```
With \[Violations] as the **column** argument and 4 as the **above** argument, the number of non-null values are calculated for each day along with the four previous days. Since the **below** argument was not specified, it defaults to 0.
\`\`\`\
MovingCount(\[Violations], 0, 4)
````
Here, the **above** argument is 0, so no previous days are included in the count. The **below** average is 4, so the count is computed for each day along with the next 4 days.
```
MovingCount([Violations], 2, 2)
````
Here, the **above** argument is 2, so the previous two days will be included in the count. In addition, the **below** argument is 2, so the following two days will be included as well.
\`\`\`\
MovingCount(\[Violations], 8, -4)
```
Here is an example where the **below** parameter is negative. The **below** parameter can be negative as long as the value is less than that of the **above** parameter. In this example, each window begins 8 days before the current day and ends 4 days before the current week, inclusive.
```
