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) |