Calculated Fields - New UI
- Matt Sullivan (Unlicensed)
While most of your reporting may only require filtering on individual columns/rows, Accelerate also includes a ‘Compute’ function for when you need to perform a function of one or more other fields.
Creating Calculations
Calculations are easily created, as long as all the data you need is available in the report. To begin creating a calculation: Click ‘Actions’ -> ‘Format’ -> ‘Compute’
It is important to name your new calculation a name if you want to use it again later! Enter a name into the ‘Column Label’ field.
Once you have named your calculation, it is time to create a computation expression. This is where you can enter the expression you wish to perform on the report columns of your choice. To help you with your expression there are three handy tools:
The ‘Columns’ list displays all columns in the current report
‘Keypad’ contains mathematical operators and integers that can be used in your expression
‘Functions/Operators’ contains a list of useful mathematical operators and functions
Format Mask can be used if your expression needs to be displayed at a certain precision or if a date, in a certain format.
Note: If the format you require isn't on the list then don't panic! You can manually enter your own mask within the text box
Viewing a Calculation
Once you are happy with your calculation, click the ‘Apply’ button. To access your calculation click ‘Actions’ then ‘Select Columns’.
The following menu will now display your calculation in the list of available columns. Calculations are denoted by ‘**’ at the beginning of the column name.
Ensure that calculation is under ‘Display in Report’, then click ‘Apply’. Your calculation will be displayed in your report:
Additional Knowledge
New Basic Reporting Advanced Filtering - New UI Formatting Reports - New UI