Advanced Options - Calculated Columns

This topic focuses on the advanced functions and features available when using Calculated Columns to enhance your reports. The ability to type formulas, functions or statements directly into the Formula field allows a knowledgeable user to extend the basic controls and commands available from the Calculated Columns' user interface.

 

Calculated Column examples

Description of Available columns

 

 

Warning: This topic is intended for users with knowledge of SQL, SQL syntax and Dovico's database structure.

 

 

General rules:

 

 

Operators

"+", "-", "*", "/", "(", ")", "=", ">", "<", "!", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9"

 

 

Functions

"CASE", "WHEN", "THEN", "ELSE", "END", "AND", "OR", "FLOOR", "CEILING", "ROUND", "SQRT", "PI", "ABS", "CONCAT", "LTRIM", "RTRIM", "SUBSTRING", "LEN", "DATEPART", "YEAR", "QUARTER", "MONTH", "DAYOFYEAR", "DAY", "WEEK", "WEEKDAY", "HOUR", "MINUTE", "DATEDIFF", "CAST", "CHAR", "VARCHAR", "AS", "INT", "FLOAT", "BIGINT", "DATETIME", "DATENAME", "RIGHT", "LEFT", "DECIMAL", "DATEADD", "CHARINDEX", "LOWER", "REPLACE", "UPPER", "DATE", "GETDATE", "LIKE"

 

Argument

"MAX" - used to specify the maximum size of a 'varchar' data type.