Overview
Calculated Columns are specialized Data Fields used in Reports to dynamically transform, extend, or manipulate existing data. These columns allow you to integrate logic through Flows, perform date/time calculations, decrypt sensitive Report Data, display icons or links, and much more, without altering the source data.
The table below describes each available Calculated Column type and its purpose.
| Calculated Column | Purpose |
|---|---|
| AddFieldByValue | Adds a constant numeric value to a selected Data Field (e.g., Total + 5). |
| AddFields | Adds the values from two numeric Data Fields together. |
| CombineTextFields | Concatenates two Data Fields into a single text column (e.g., FirstName + LastName). |
| ConstantValueInlineField | Inserts a fixed value into each row. Supports String, Int, Decimal, Boolean, and DateTime. Useful for Truth Table comparisons. |
| CustomActionsField Field (v9.12+ & Adv Data Grid Only) | Displays one or more action icons (e.g., buttons) inline per row. Each action can trigger a Flow or outcome. |
| CustomIconsField (v9.14+) | Displays one or more icons inline in a column. Icons can be conditionally shown based on row data, and each can include tooltips. Ideal for compact visual indicators. |
| DivideFieldByValue | Divides the value of a Data Field by a constant value. |
| DivideField | Divides one Data Field by another (e.g., Sales / Units). |
| EncryptedOrPIIDataField | Decrypts sensitive or personally identifiable information (PII) at runtime, assuming proper permissions. |
| FilterRegex (v9.2+) | Filters row values based on a regular expression pattern. Only rows matching the pattern are displayed. |
| FlowInlineField | Executes a Flow per row and returns a result (typically a string or value) to be displayed in the column. Useful for complex lookups or logic. |
| GetDateAge | Calculates the time difference between a date column and today, returning a human-readable format (e.g., "2 years, 3 months"). |
| GetDate | Outputs the Date for the selected Data Field. |
| GetDayofWeek | Returns the weekday name (e.g., Monday) of a DateTime field. |
| GetDaysBetween | Calculates the number of days between two date columns. |
| GetHoursBetween | Gets hours difference between two dates. |
| GetMilliSecondsBetween | Displays milliseconds difference between two dates. |
| GetMinutesBetween | Works out the difference between the two dates. |
| GetMonth | Gets month number without year from selected Data Field. To use this, change Data Field Format to Other and define Properties > Formatting > Format as MMMM. |
| GetRemainderFromFields | Determines remainder from two Data Fields. |
| GetSecondsBetween | Gets seconds difference between two dates. |
| GetTimesBetween | Evaluates the time difference between the two dates. |
| GetYear | Extracts the year portion from a DateTime field. |
| HideOldDates | Hides or displays null values from a Data Field based on the value provided in Hide Dates Older Than field |
| ImageDocumentInlineField | Displays a Document as an inline field on the Report. |
| ImageUrlInlineField | Allows displaying of an Image as a column in a Report |
| LiveUpdateColumnInlineField | Displays the number of days, hours, or minutes that have passed based on a DateTime column. The Background and Foreground colors can be set based on a positive or negative value. Positive means time until, and negative means time that has passed. |
| MatchInlineField | Adds column where the user can put conditions to show different values on each row as desired |
| MatchRegex | Filters RegexPattern provided by the user for a Data Field and displays only the rows where RegexPattern is matched |
| MergeTextInlineField | Provides the Text Merge Editor where multiple Data Fields can be grouped together |
| MultiplyFieldByValue | Multiplies the value with the selected Data Field |
| MultiplyFields | Allows the option to multiply two Data Fields |
| OpenURLInlineField | Constructs a URL and provides a link at runtime to open that URL |
| PercentField | Calculates a percentage using two Data Fields |
| RunFlowInlineField | Runs a Flow from a Report |
| SplitCamelCaseInlineField | Returns column data in Camel Case form |
| SubtractFieldByValue | Subtracts value from selected Data Field |
| SubtractFields | Subtracts two Data Fields |
| TimespanTotalSecondsField | Displays timespan in seconds |
| TimespanTotalMinutesField | Outputs timespan in minutes |
| TimespanConstantFormatField | Provides timespan in a Constant defined format: hh\:mm\:ss |
| TimespanCustomFormatField | Displays timespan in a custom-defined format; the default format is hh\:mm\:ss |
| TruncateTextInlineField | Shortens the value of another Data Field |
| YesNoInlineField | Displays Yes or No values and can be used with a Boolean column |
Feature Changes
| Description | Version | Release Date | Developer Task |
|---|---|---|---|
| Added the Regex Pattern filter | 9.2 | August 14, 2024 | [DT-041657] |
| Added CustomActionsField | 9.12 | June 2025 | [DT-043985] |
| Added CustomIconsField | 9.14 | August 2025 | [DT-043989] |
For further information on Reports, visit the Decisions Forum.