Returns the absolute value of a number
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)
Rounds a number up to the next largest whole number or integer
Returns the count of values
Returns the distinct count of values
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
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