To add a Custom Calc field to a user report, select the <Custom Calc Field> under the Available Data Fields section, and click on
.
The <Custom Calc Field> will appear under the Selected Data Fields section. Rename the Column Caption and populate the Formula field that appears when a calculated field is selected.
Click on
to finalize changes made to the user report.
The following functions can be used for a <Custom Calc Field>:
Maths functions (+, - , /, *)
IIF statement
Combine multiple data fields (Concatenation)
ISNULL compares values until it finds a non-blank value
HTML links
HTML formatting
Things to Note
Only one <Custom Calc Field> can be added at a time
Can only use Column Caption to refer to a field
A Custom Calc field cannot be used to filter the report.