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 Length |
| Returns the number of items in an array for a given input. An optional | 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: |
Inner Items Count |
| Returns the count of inner items contained within a root | Input: Result: |
Last Index Of |
| Returns the last index of | 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: |
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 | 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: |
To Timestamp |
| Returns the Unix time for a specified date. | Input: Result: |
Trunc |
| Limits the number of digits of | 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: |