Functions
Functions are used to perform basic math, grouping, or display only part of a value. To add a function, perform one of the three methods listed below:
Adding a Function (Method 1)
Scroll below the
Fields
box to locate the Functions
box. Click on the expansion arrow on the far right of the Functions
box.
Choose a function from the
Functions
box to include. Once a function is selected, click on the function name. Drag the selected function into the Selected Items
box and release.
A pop-up will appear, explaining what the function does. Enter a Result Column Name and then choose a field from the
Add a Numeric field
… textbox. This box has a type-ahead feature to autocomplete a field name. Once both of these parameters are set, click Save
to proceed.
Adding a Function (Method 2)
Scroll below the
Fields
box to locate the Functions
box. Click on the expansion arrow on the far right of the Functions
box.
Choose a function from the
Functions
box to include. Once a function is selected, click the +
button.
A pop-up will appear, explaining what the function does.
Enter a Result Column Name and then choose a field from the
Add a Numeric field
… textbox. This box has a type-ahead feature to autocomplete a field name.For some (but not all) functions, only numeric fields can be selected.
Once both of these parameters are set, click
Save
to proceed.
Adding a Function (Method 3)
Click the + button on the far right of the
Selected Items
box.
A drop-down will appear on the right. From the drop-down, click
Add Function
.
Clicking
Add Function
will open the Select Function
pop-up. Choose a function from the list and then click Select
.
A pop-up will appear, explaining what the function does. Enter a Result Column Name and then choose a field from the
Add a Numeric field
… textbox. This box has a type-ahead feature to autocomplete a field name. Once both of these parameters are set, click Save
to proceed.
Editing Functions
To edit a function, go to the
Selected Items
box and choose a function to be edited. Once a function is selected, click the function’s corresponding pencil icon in the Selected Items
display box.
The
Edit Function
pop-up will open. Make any necessary changes and save.
Removing Functions
To remove a function, go to the
Selected Items
box and choose a function to be removed. Once a function is selected, click the function’s X
icon.
The function will then be removed from the report.
Adding a Function Based Off Plural Values
The
ADD
function can be used to create a column that contains values from two different numeric fields. For example, the values of AddlDuty
and AdValoremDuty
can be combined to create a new sum report column called TotalLineDuty
.ADD is located at the bottom of the
Functions
table and requires to select two numeric fields and name the result column. Once these values are provided, click Save
to proceed.
Related Content
-
Report Builder
Format:
Article