Available Calculated Field Expressions

Function Name Syntax
expression expression
+ expression + expression
- expression - expression
/ expression / expression
< expression < expression
<= expression <= expression
<> expression <> expression
= expression = expression
> expression > expression
>= expression >= expression
AND boolean_expression AND boolean_expression
AVG AVG (expression)
BETWEEN BETWEEN (test_expression, begin_expression, end_expression)
CASE WHEN…THEN…ELSE…END CASE WHEN (boolean_expression) THEN (result_expression) […n] [ELSE (else_result_expression)] END
CASE…WHEN…THEN…ELSE…END CASE (input_expression) WHEN (when_expression) THEN (result_expression) […n] [ELSE (else_result_expression)] END
CAST…AS CAST (expression AS data_type)
CONCAT CONCAT (expression, expression[,expression…])
CONVERT CONVERT (data_type [( length)], expression[, style])
COUNT COUNT (expression)
DATEADD DATEADD (datepart, number, expression)
DATEDIFF DATEDIFF (datepart, startdate, enddate)
DATEPART DATEPART (datepart, date)
DISTINCT DISTINCT (column) or DISTINCT column
GETDATE GETDATE ()
IF…THEN…ELSE…END IF (boolean_expression) THEN (true_expression) [ELSE (false_expression)] END
IIF IIF (boolean_expression, true_expression, [false_expression])
ISNULL ISNULL (check_expression, replacement_value)
LEN LEN (expression)
MAX MAX (expression)
MIN MIN (expression)
OR boolean_expression OR boolean_expression
ROUND ROUND (expression, length[, function])
RUNNING AVG RUNNINGAVG (column)
RUNNING COUNT RUNNINGCOUNT (column)
RUNNING SUM RUNNINGSUM (column)
SUM SUM (expression)