1. Calculation functions
  2. All Functions
  3. Numeric Functions
Name Description
ABS Returns the absolute value of a number.
x[ALL:y] Flags where all list items are populated with a checkmark (used with Boolean format).
x[ANY:y] Flags where any list items are populated with a checkmark (used with Boolean format).
x[AVERAGE:y] Calculates the average for a specified range of values.
EXP Returns e raised to the nth power, where e = 2.71828183.
FIRSTNONZERO This takes at least two numeric arguments, and returns the first that is non-zero.
LN Returns the natural logarithm of a number, based on the constant e.
LOG Returns the logarithm of a number to the specified base.
MAX Maximum value of selected line items.
x[MAX:y] The maximum value for a specified list item of one of the dimensions of the target. The source will have a list-formatted item for this dimension.
MID Extract a substring from a string starting at any character.
MIN Minimum of selected line items.
x[MIN:y] The minimum value for a specified list item of one of the dimensions of the target. The source will have a list-formatted item for this dimension.
MOD Modulus: remainder after dividing a dividend by a divisor.
MROUND Round to the nearest desired multiple.
POWER Raise a value to a power.
ROUND Rounds a value to a specified number of decimal places.
SIGN Show the sign of a number (result = -1 if the value is negative, 1 if positive, 0 if zero).
SQRT Square root of a value.