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.