# Numerical calculations

Returns the absolute value of a number
`ABS([Delta])`
Returns the avg of a series of numbers
`AVG([Price] + ([Price] * [Tax Rate])/100)`
Returns the conditional avg of a series of numbers
`AVGIF([Price] + ([Price] * [Tax Percent])/100, [Price] > 0)`
Returns the count of values
`COUNT([ID])`
Returns the distinct count of values
`COUNT_DISTINCT([ID])`
Returns the conditional count of values
`COUNTIF([ID], [Project] != 'OS')`
Returns the conditional count of values
`COUNTIF_DISTINCT([ID], [Project] != 'OS')`
Returns the difference between the specified start date and end date
`DATEDIFF([Created On], [Completed On], 'year')`
Returns provided date part of date as a number
`DATEPART([Created On], 'year')`
Returns the running difference for the given expression between current value and previous
`DIFFERENCE(SUM([Hours Spent]))`
Returns the length of text
`LENGTH('Hulk')`
Returns the max of a series of numbers
`MAX([Price] + ([Price] * [Tax Rate])/100)`
Returns the conditional max of a series of numbers
`MAXIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)`
Returns the median of a series of numbers
`MEDIAN([Price] + ([Price] * [Tax Rate])/100)`
Returns the min of a series of numbers
`MIN([Price] + ([Price] * [Tax Rate])/100)`
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)`
Rounds a number
`ROUND([Price] + ([Price] * [Tax Rate])/100)`
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 sum of a series of numbers
`SUM([Price] + ([Price] * [Tax Rate])/100)`
Returns the conditional sum of a series of numbers
`SUMIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)`
Returns the total for a given aggregation across the whole dataset
`TOTAL(SUM([Price]))`