Calculated Column Overview

Prev Next

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 ColumnPurpose
AddFieldByValueAdds a constant numeric value to a selected Data Field (e.g., Total + 5).
AddFieldsAdds the values from two numeric Data Fields together.
CombineTextFieldsConcatenates two Data Fields into a single text column (e.g., FirstName + LastName).
ConstantValueInlineFieldInserts 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.
DivideFieldByValueDivides the value of a Data Field by a constant value.
DivideFieldDivides one Data Field by another (e.g., Sales / Units).
EncryptedOrPIIDataFieldDecrypts 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.
FlowInlineFieldExecutes 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.
GetDateAgeCalculates the time difference between a date column and today, returning a human-readable format (e.g., "2 years, 3 months").
GetDateOutputs the Date for the selected Data Field.
GetDayofWeekReturns the weekday name (e.g., Monday) of a DateTime field.
GetDaysBetweenCalculates the number of days between two date columns.
GetHoursBetweenGets hours difference between two dates.
GetMilliSecondsBetweenDisplays milliseconds difference between two dates.
GetMinutesBetween

Works out the difference between the two dates.

GetMonthGets month number without year from selected Data Field.

To use this, change Data Field Format to Other and define Properties > Formatting > Format as MMMM. 
GetRemainderFromFieldsDetermines remainder from two Data Fields.
GetSecondsBetweenGets seconds difference between two dates.
GetTimesBetweenEvaluates the time difference between the two dates.
GetYearExtracts the year portion from a DateTime field.
HideOldDatesHides or displays null values from a Data Field based on the value provided in Hide Dates Older Than field
ImageDocumentInlineFieldDisplays a Document as an inline field on the Report.
ImageUrlInlineFieldAllows displaying of an Image as a column in a Report
LiveUpdateColumnInlineFieldDisplays 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.
MatchInlineFieldAdds column where the user can put conditions to show different values on each row as desired
MatchRegexFilters RegexPattern provided by the user for a Data Field and displays only the rows where RegexPattern is matched
MergeTextInlineFieldProvides the Text Merge Editor where multiple Data Fields can be grouped together
MultiplyFieldByValueMultiplies the value with the selected Data Field
MultiplyFieldsAllows the option to multiply two Data Fields
OpenURLInlineFieldConstructs a URL and provides a link at runtime to open that URL
PercentFieldCalculates a percentage using two Data Fields
RunFlowInlineFieldRuns a Flow from a Report
SplitCamelCaseInlineFieldReturns column data in Camel Case form
SubtractFieldByValueSubtracts value from selected Data Field
SubtractFieldsSubtracts two Data Fields
TimespanTotalSecondsFieldDisplays timespan in seconds
TimespanTotalMinutesFieldOutputs timespan in minutes
TimespanConstantFormatFieldProvides timespan in a Constant defined format: hh\:mm\:ss
TimespanCustomFormatFieldDisplays timespan in a custom-defined format; the default format is hh\:mm\:ss 
TruncateTextInlineFieldShortens the value of another Data Field
YesNoInlineFieldDisplays Yes or No values and can be used with a Boolean column

Feature Changes

DescriptionVersionRelease DateDeveloper Task
Added the Regex Pattern filter9.2August 14, 2024[DT-041657]
Added CustomActionsField9.12
June 2025[DT-043985]
Added CustomIconsField9.14
August 2025[DT-043989]


For further information on Reports, visit the Decisions Forum.