Numbers
Operation | Format | Description | Example |
---|---|---|---|
Add Time |
| Adds units of time to a specified date and time, returning a result in Unix time. | Input: Result: |
Array Sum |
| Sum of two or more values provided in an array. | Input: Result: |
Average |
| Average of the total across the columns. There is no limit to the number of columns that be used in this formula. | Input: Result: |
Convert to Number |
| Converts a value from any formatted number field into an integer. | Input: Result: |
Date Diff |
| Difference in time between two dates, in the time unit specified. | Input: Result: |
Days Differential |
| Difference in days between two dates in the specified time zone. | Input: Result: |
Divide |
| Product of two values divided by one another. | Input: 26/13 Result: 2 |
Hour |
| Returns the hour for a specified time and time zone. | Input: Result: |
Index of |
| Returns the first index of | Example: Input: Result: Example: Input: Result: |
Last Index of |
| Returns the last index of | Input: Result: |
Length |
| Returns the number of characters in the input string | Input: Result: |
Maximum |
| Largest value of all the values across the columns. There is no limit on the number of columns that can be used in this formula. | Input: Result: |
Minimum |
| Smallest value of all the values across the columns. There is no limit on the number of columns that can be used in this formula. | Input: Result: |
Minute |
| Returns the minute value of | Input: Result: |
Mod |
| Returns the remainder after a division operation. | Input: Result: |
Multiply |
| Product of two fields multiplied together. | Input: Result: |
Percentage |
| Portion of a whole value expressed as a percentage. | Input: Result: |
Pow |
| Product of one value to the power of another value. | Input: Result: |
Random |
| Returns a random number from within a specified range. The starting number and maximum number are included within the range. | Input: Result: |
Round |
| Rounds {A} to a specified number of places {B}. | Input: Result: |
Square Root |
| Square root of a value. | Input: Result: |
String Length |
| Returns the length of the input string as a numeral. | Input: Result: |
Subtract |
| Difference between two or more values. | Input: Result: |
Sum |
| Sum of two or more values. | Input: Result: |
Take Not Empty |
| The first value that is not empty from a list of values. | Input: Result: |
To Timestamp |
| Returns the Unix time for a specified date. | Input: Result: |
Trunc |
| Limits the number of digits of {A} to {B} number of places. | Input: Result: |
Week Number |
| Returns the number of the week in the year (that is, n out of 52 weeks in the year).
| Input: Result: |