Simple calculated fields like concatenation or a simple calculation can be completed using the calculated fields. To add a calculated field to a user report, select “<Custom Calc Field>” from the available field list and click

. Once the Custom Calculated Field has been added, modify the Column Caption and Formula.

Note - To reference another field in a calculated field, copy the Column Caption of the field that you want to use into the Formula and place square brackets (“[“ and “]”) around the caption. This is different from the Custom SQL Field where the Field value is referenced in the Formula field.

On the following example, a calculated field has been added to concatenate the First and Last Name of the Employee.

Another calculated field was added to compute for the Typical Foreign Service Premium by multiplying the employee's Annual Base Pay by a value of 1.15.

On the following example, calculated fields have been added to:

When creating Calculated Fields that reference other fields on the report, use the caption values from the user report.

For example, if the name for one column/caption is "UnitPrice", and another "Quantity", the expression would be:

When creating an Evaluation Clause for a filter, enclose strings with single quotes:

Decimals and scientific notation are permissible for numeric values. For example:

For more information on what operators and operations can be used for custom calculation fields, please follow this link.