Calculated Column Overview
- 26 Aug 2022
- 2 Minutes to read
- Print
- DarkLight
This documentation version is deprecated, please click here for the latest version.
Calculated Column Overview
- Updated on 26 Aug 2022
- 2 Minutes to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Calculated Columns are Data Fields that extend Report Data 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 | Allow user to add value to selected Data Field |
AddFields | Allows the user to add two Data Fields together |
CombineTextFields | Allows the 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. |
DivideFieldByValue | Allows the user to divide a Data Field by the desired value |
DivideField | Allows the user to divide two Data Fields |
EncryptedOrPIIDataField | Allows the user to decrypt encoded data defined when creating a Data Structure |
FlowInlineField | Allows the user to define and run a Flow to perform lookups by displaying strings in a Report |
GetDateAge | Show the year, month, and day duration between the selected column date and the current. |
GetDate | Gets the current Date |
GetDayofWeek | Get the day of the week from the selected Data Field |
GetDaysBetween | Get days difference between two dates |
GetHoursBetween | Get the hours difference between two dates |
GetMilliSecondsBetween | Get milliseconds difference between two dates |
GetMinutesBetween | Get minutes difference between two dates |
GetMonth | Get the month number without year from the selected Data Field. |
GetRemainderFromFields | Get the remainder from two Data Fields |
GetSecondsBetween | Get seconds difference between two dates |
GetTimesBetween | Get the time difference between two dates |
GetYear | Get a year from a selected Data Field |
HideOldDates | Allows the user to hide or display null values from a Data Field based on the value provided in the Hide Dates Older Than field |
ImageDocumentInlineField | Allows Displaying a Document as an inline field on the Report |
ImageUrlInlineField | Allows displaying 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 | Allows the user to multiply the value with the selected Data Field |
MultiplyFields | Allows the user to multiply two Data Fields |
OpenURLInlineField | Allow user to construct an URL and provide a link at runtime to open that URL |
PercentField | Allows the user to calculate a percent using two Data Fields |
RunFlowInlineField | Allows the user to run a Flow from a Report |
SplitCamelCaseInlineField | Return column data in Camel Case form |
SubtractFieldByValue | Allow the user to subtract values from the selected Data Field |
SubtractFields | Subtracts two selected Data Fields |
TimespanTotalSecondsField | Displays timespan in seconds |
TimespanTotalMinutesField | Displays timespan in minutes |
TimespanConstantFormatField | Displays timespan in a constant format: hh\:mm\:ss |
TimespanCustomFormatField | Displays timespan in a custom format; the default format is hh\:mm\:ss |
TruncateTextInlineField | Displays the shortened value of another Data Field |
YesNoInlineField | Displays Yes or No values and can be used with a Boolean column; a Boolean column shows True or False values |
For further information on Reports, visit the Decisions Forum.
Was this article helpful?