--- title: "Calculated Column Overview" slug: "calculated-column-overview" description: "Configure Calculated Columns in Reports to transform data, apply custom logic, calculate values, and display dynamic icons or links." tags: ["Report customization"] updated: 2026-06-17T16:37:45Z published: 2026-06-17T16:37:45Z canonical: "documentation.decisions.com/calculated-column-overview" --- > ## Documentation Index > Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt > Use this file to discover all available pages before exploring further. # Calculated Column Overview ## Overview Calculated Columns are specialized [Data Fields](https://documentation.decisions.com/version-10/docs/reports#:~:text=on%20the%20Report.-,Data%20Fields,-Allows%20users%20to) used in [Reports](https://documentation.decisions.com/version-10/docs/reports#:~:text=A-,Report,-is%20a%20Designer) to transform, extend, or manipulate existing data dynamically. These columns allow you to integrate logic through Flows, perform date/time calculations, [decrypt sensitive Report Data](https://documentation.decisions.com/version-10/docs/decrypting-pii-data-fields-with-a-report) 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](https://documentation.decisions.com/version-10/docs/data-extensions) | 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 displayed based on row data, and each can include a tooltip. 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](https://documentation.decisions.com/version-10/docs/decrypting-pii-data-fields-with-a-report) | 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](https://documentation.decisions.com/version-10/docs/using-flow-inline-fields-to-extend-report-data) | 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"). In **v9.22** and up, Users can use the **Show as Number** property to display the time between a selected date and today as an integer for years, months, or days. | | 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 the hours difference between two dates. | | GetMilliSecondsBetween | Displays milliseconds difference between two dates. | | GetMinutesBetween | Works out the difference between the two dates. | | GetMonth | Gets the month number without the year from the selected Data Field. To use this, change Data Field Format to Other and define Properties > Formatting > Format as MMMM. | | GetRemainderFromFields | Determines the remainder from two Data Fields. | | GetSecondsBetween | Gets the 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 the 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 a column where the user can put conditions to show different values on each row as desired | | MatchRegex | Filters the RegexPattern provided by the user for a Data Field and displays only the rows where the RegexPattern is matched | | MergeTextInlineField | Provides the Text Merge Editor, where multiple Data Fields can be grouped together | | MultiplyFieldByValue | Multiplies the value by the selected Data Field | | MultiplyFields | Allows the option to multiply two Data Fields | | [OpenURLInlineField](https://documentation.decisions.com/version-10/docs/embedded-links-reports) | Constructs a URL and provides a link at runtime to open that URL | | PercentField | Calculates a percentage using two Data Fields | | [RunFlowInlineField](https://documentation.decisions.com/version-10/docs/using-flow-inline-fields-to-extend-report-data) | Runs a Flow from a Report | | SplitCamelCaseInlineField | Returns column data in Camel Case form | | SubtractFieldByValue | Subtracts value from the 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](https://documentation.decisions.com/v99/docs/version-92x-release-notes) | August 14, 2024 | [DT-041657] | | Added CustomActionsField | [9.12](https://documentation.decisions.com/v99/docs/version-912x-release-notes) | June 2025 | [DT-043985] | | Added CustomIconsField | [9.14](https://documentation.decisions.com/v99/docs/version-914x-release-notes) | August 2025 | [DT-043989] | | Added a new property for the GetDateAge calculated column that allows Users to display the time between a date and today. | [9.22](https://documentation.decisions.com/v99/docs/version-922x-release-notes?highlight=DT-046818) | March 2026 | [DT-046818] |