Calculated Column Overview
- 12 Aug 2024
- 2 Minutes to read
- Print
- DarkLight
Calculated Column Overview
- Updated on 12 Aug 2024
- 2 Minutes to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Calculated Columns are Data Fields used to extend data on a Report by allowing the ability to incorporate other Designer Elements (e.g. Flows), get specific calculated DateTime values, to decrypt sensitive Report Data, and more.
The table below displays each possible Calculated Column as well as its function.
| Calculated Column | Function |
|---|---|
| AddFieldByValue | Used to add value to selected Data Field |
| AddFields | Allows the ability to add two Data Fields together |
| CombineTextFields | Provides function user to combine two Data Fields into one column |
| ConstantValueInlineField | Allows the user to define Constant values according to the DataTypes of values such as String, Int, Decimal, Boolean, and the DateTime type Useful with the External Truth Table to compare values |
| DivideFieldByValue | Divides a Data Field by the desired value |
| DivideField | Used to split up two Data Fields |
| EncryptedOrPIIDataField | Decrypts encoded data defined when creating a Data Structure |
| FilterRegex (v9.2+) | This column will take a Regex pattern and filter the data. |
| FlowInlineField | Defines and runs a Flow to perform lookups by displaying strings in a Report |
| GetDateAge | Shows duration in the year, month, and days between the selected column date to the current |
| GetDate | Outputs the current Date |
| GetDayofWeek | Gets the day of the week from the selected Data Field |
| GetDaysBetween | Calculates the difference in days between two dates |
| 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 | Pulls year from selected Data 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] |
For further information on Reports, visit the Decisions Forum.
Was this article helpful?
