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)