There are three types of special Calculation Columns in Apricot's Report Builder: Number Calc, Date/Time Calc, and Text Calc. Multiple calculation columns can be added to a section, and the results from one calculation column can be used in subsequent calculation columns.

Text Calc columns can combine the values of multiple columns into one or combine a column's text with a static value that you designate. Follow the steps listed below to learn how to concatenate text data within a report column.

Note: Despite its name, this function is not actually limited to the text columns in your report; it can be used to combine the data from numeric columns as well.

In the upper right-hand corner of the Report Builder, click on Special Columns in the Field Choices palette then expand Calculation Columns. Drag and drop the Text Calc column into your report section.

Note: Static Values in Text Calc columns have a 35-character limit.

Open the column properties by clicking the gear icon next to the calculation column's name.

You can create a column name in the Name field based on what it's meant to calculate. In this example, we are concatenating the text values from the First and Last fields to display Participants' full names in a single column.

There is only one Calculation Type option for Text Calc columns: Combine. This will concatenate the values that appear in whatever columns you select.

In the Calculation Columns section, use the dropdown fields to select which values you want to combine in a single column. You'll find all your fields listed here as columns of any data type can be used in a Text Calc. You can also add more columns to the Text Calc by clicking the + icon.

Choosing [Static Value] in the dropdown allows you to type in your own text value to use in the calculation. We recommend adding spaces between the columns for easier readability in the report. For example, we typed a space into a static value field to display the full name as "First Last" as opposed to "FirstLast".

Once the column's properties have been set, select Apply to save your changes.

Finally, save your report from the Report Actions palette. You can also publish the report to make the changes immediately available to other users running the report.