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.