Returns the conditional avg of a series of numbers

`AVGIF([Price] + ([Price] * [Tax Percent])/100, [Price] > 0)`

Returns the difference between the specified start date and end date

`DATEDIFF([Created On], [Completed On], 'year')`

Returns the running difference for the given expression between current value and previous

`DIFFERENCE(SUM([Hours Spent]))`

Returns the conditional max of a series of numbers

`MAXIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)`

Returns the conditional min of a series of numbers

`MINIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)`

Returns the value at a given percentile of a dataset

`PERCENTILE([Price] + ([Price] * [Tax Rate])/100, 0.3)`

Returns the running avg for a given expression from the first row to the current.

`RUNNING_AVG(SUM([Hours Spent]))`

Returns the running max for a given expression from the first row to the current

`RUNNING_MAX(SUM([Hours Spent]))`

Returns the running min for a given expression from the first row to the current

`RUNNING_MIN(SUM([Hours Spent]))`

Returns the running sum for a given expression from the first row to the current

`RUNNING_SUM(SUM([Hours Spent]))`

Returns the standard deviation of a series of numbers

`STDEV([Price] + ([Price] * [Tax Rate])/100)`

Returns the conditional sum of a series of numbers

`SUMIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)`