Supported Metric Formulas
The following table lists the supported Metric formula. These formulas are applicable only to Parent and Formula type metric.
The data type for this metric 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 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 in radians. |
ASIN(0.5) → Returns 0.524 |
ATAN |
Returns the principal value of the arctangent in radians. |
ATAN(1) → Returns 0.785 |
CEILING |
Rounds a number up to the nearest integer or multiple. |
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. |
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 portion of text from the left. |
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 characters from text starting at a given 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. |
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. |
For more information on Metric Types see Metric Details.