# CumulativeCorr

The **CumulativeCorr** function calculates the correlation coefficient of the input column up to and including the current value.

### Syntax

```
CumulativeCorr([Column 1], [Column 2])
```

Function Arguments:

* **\[Column 1]** (required) - The column representing the dependent data.
* **\[Column 2]** (required) - The column representing the independent data.

> ### 📘
>
> Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.

### Example

```
CumulativeCorr([Weekly Cost], [Weekly Revenue])
```

A table contains the weekly revenue of a store and the total amount spent by that store that week.  The **CumulativeCorr** function can be used to find the correlation coefficient up to and including each row value.

<figure><img src="https://files.readme.io/d33b12a-mmm.png" alt=""><figcaption></figcaption></figure>