Operators and Functions in Calculated Columns

Table overview of operators and functions available for use in Calculated Columns with certain data types. For more detailed explanation of operators and functions, consult Alchemy Script User Manual (Link)

‍^** Functions calculating the value of all rows in one column

^***Returns the number value as an output, number type of data should be selected

List of functions from the table

Functions

• SQRT                                   
• POW
• ABS
• LOG
• ROUND 
• SUM
• AVERAGE
• COUNT
• ROW_COUNT

Statistical functions

• P_CORREL
• S_CORREL
• MAX
• MIN
• MEDIAN
• MODE_SINGLE
• MODE_MULTIPLE
• PERCENTILE
• STDEV

Date and Time functions

• DATE_DIFF
• END_OF
• DATE_ADD
• DATE_GET