Supported Metric Formulas
The following table lists the supported metric formulas. These formulas are applicable only to Parent and Formula type metrics.
Note: The data type for such metrics must be Numeric.
Function |
Description |
Example |
|---|---|---|
+ |
Adds values together. |
5 + 3 → Returns 8 |
- |
Subtracts one value from another. |
10 - 4 → Returns 6 |
* |
Multiplies two values. |
6 * 2 → Returns 12 |
/ |
Divides one value by another. |
12 / 3 → Returns 4 |
ABS |
Returns the absolute (non negative) value of a number. |
ABS(-8) → Returns 8 |
ACOS |
Returns the principal value of the arccosine of a number. The angle is returned in radians. |
ACOS(0.5) → Returns 1.047 |
|
v25.05: AND |
Returns TRUE if all specified conditions are met; otherwise, returns FALSE. |
IF(AND('Metric 1' >0, 'Metric 2' >0), 'Metric 3', 0) |
ASIN |
Returns the principal value of the arcsine of a number. The angle is returned in radians. |
ASIN(0.5) → Returns 0.524 |
ATAN |
Returns the principal value of the arctangent of a number. The angle is returned in radians. |
ATAN(1) → Returns 0.785 |
CEILING |
Rounds a number up to the nearest integer or multiple of significance. |
CEILING(5.3, 1) → Returns 6 |
CHAR |
Returns a character represented by a number. |
CHAR(65) → Returns "A" |
|
v25.05: & / CONCATENATE |
Combines multiple text values into a single string. |
"John" & "Doe" → Returns "JohnDoe" CONCATENATE("Item", " - ", "001") → Returns "Item - 001" |
COS |
Returns the cosine of an angle in radians. |
COS(0) → Returns 1 |
COT |
Returns the cotangent of an angle in radians. |
COT(1) → Returns 0.642 |
v25.05: FIXED |
Rounds a number to a specified number of decimals and formats the result as text. Can include or exclude commas. |
FIXED(1999.544, 2, TRUE) → Returns "1999.54" (without commas) FIXED(1999.544, 2, FALSE) → Returns "1,999.54" (with commas) |
FLOOR |
Rounds a number down to the nearest multiple of the second parameter. |
FLOOR(5.8, 1) → Returns 5 |
IF |
Returns one of two values based on a condition. |
IF(5 > 3, "True", "False") → Returns "True" |
LEFT |
Extracts a specified number of characters from the left of a text string. |
LEFT("Hello", 2) → Returns "He" |
LOG |
Returns the logarithm of a number to a given base. |
LOG(100, 10) → Returns 2 |
LOWER |
Converts text to lowercase. |
LOWER("HELLO") → Returns "hello" |
v25.05: MAX |
Returns the largest value from a set of numbers. |
MAX(A1:A10) |
MID |
Extracts a specific number of characters from a text string, starting at a specified position. |
MID("Example", 3, 4) → Returns "ampl" |
|
v25.05: MIN |
Returns the smallest value from a set of numbers. |
MIN(A1:A10) |
MOD |
Returns the remainder when dividing numbers. |
MOD(10, 3) → Returns 1 |
NOW |
Returns the current date and time. |
NOW() → Returns "2025-05-29 17:26:00" |
|
v25.05: OR |
Returns TRUE if at least one of the specified conditions is met; otherwise, returns FALSE. |
IF(OR('Metric 1' >0, 'Metric 2' >0), 'Metric 3', 0) |
PI |
Returns the mathematical constant pi. |
PI() → Returns 3.1415926535 |
POWER |
Raises a number to the power of another number. |
POWER(2, 3) → Returns 8 |
RADIANS |
Converts degrees to radians. |
RADIANS(180) → Returns 3.141 |
REPLACE |
Replaces part of a text string with new text. |
REPLACE("Hello", 2, 3, "abc") → Returns "Habclo" |
RIGHT |
Extracts characters from the right side of a text. |
RIGHT("Example", 3) → Returns "ple" |
|
v25.05: ROUNDUP |
Rounds a number up to the nearest specified decimal place. |
ROUNDUP(5.234, 2) |
|
v25.05: ROUNDDOWN |
Rounds a number down to the nearest specified decimal place. |
ROUNDDOWN(5.234, 2) |
SIGN |
Returns 1 for positive numbers, -1 for negative, 0 for zero. |
SIGN(-10) → Returns -1 |
SIN |
Returns the sine of an angle in radians. |
SIN(0) → Returns 0 |
SQRT |
Returns the square root of a number. |
SQRT(9) → Returns 3 |
SUM |
Adds a set of numbers, including all numbers in a range. |
SUM(2, 3, 5) → Returns 10 |
TAN |
Returns the tangent of an angle in radians. |
TAN(1) → Returns 1.557 |
TRIM |
Removes extra spaces from text. |
TRIM(" Hello ") → Returns "Hello" |
|
v25.05: VALUE |
Converts a text string into a numeric value, allowing for calculations and comparisons. |
VALUE("123") → Converts the text "123" into the number 123 for numeric operations. |