Supported Metric Formula
The following table lists the supported Metric formula. These formula are applicable only to Parent and Formula type metric.
Note: The data type for this metric must be Numeric.
Function |
Description |
Example |
|---|---|---|
+ |
Adding Values |
|
- |
Minus |
|
* |
Multiply |
|
/ |
Divide |
|
ABS |
Returns the absolute (nonnegative) value of a number. |
|
ACOS |
Returns the principal value of the arccosine of a number. The angle is returned in radians. |
|
AND |
Returns TRUE if all specified conditions are met; otherwise, returns FALSE. |
IF(AND('Metric 1' >0, 'Metric 2' >0), 'Metric 3', 0) Displays 'Metric 3' if both Metric 1 and Metric 2 are greater than zero; otherwise, returns 0. |
ASIN |
Returns the principal value of the arcsine of a number. The angle is returned in radians. |
|
ATAN |
Returns the principal value of the arctangent of a number. The angle is returned in radians. |
|
CEILING |
Rounds a number to the nearest integer or to the nearest multiple of significance. |
|
CHAR |
Return character represented by a given number. |
|
& / CONCATENATE |
Combines multiple text values into a single string. |
"John" & "Doe" → Returns "JohnDoe". CONCATENATE("Item", " - ", "001") → Returns "Item - 001". |
COS |
Returns the cosine of a number. The angle is returned in radians. |
|
COT |
Returns the cotangent of an angle, specified in radians. |
|
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. |
|
IF |
Returns one of two values, depending on a condition. |
|
LEFT |
Returns a selected number of text characters from the left. |
|
LOG |
Returns the logarithm of a number to a specified base. |
|
LOWER |
Converts text to lowercase. |
|
MAX |
Returns the largest value from a set of numbers. |
MAX(A1:A10) Returns the largest number from the range A1 to A10. |
MID |
Returns a specific number of characters from a text string, starting at a specified position. |
|
MIN |
Returns the minimum value in a set of numbers. |
|
MIN |
Returns the smallest value from a set of numbers. |
MIN(A1:A10) Returns the smallest number from the range A1 to A10. |
MOD |
Returns the remainder when one number is divided by another number. |
|
NOW |
Returns the serial number of the current date and time. |
|
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) Displays 'Metric 3' if either Metric 1 or Metric 2 is greater than zero; otherwise, returns 0. |
PI |
Returns the approximate value of pi. |
|
POWER |
Returns the result of a number raised to the power of another number. |
|
RADIANS |
Converts degrees to radians. |
|
REPLACE |
Replaces characters within text. |
|
RIGHT |
Returns the rightmost characters from a text value. |
|
ROUNDUP |
Rounds a number up to the nearest specified decimal place. |
ROUNDUP(5.234, 2) Returns 5.24, rounding up to two decimal places. |
ROUNDDOWN |
Rounds a number down to the nearest specified decimal place. |
ROUNDDOWN(5.234, 2) Returns 5.23, rounding down to two decimal places. |
SIGN |
Returns the sign of a number. |
|
SIN |
Returns the sine of an angle specified in radians. |
|
SQRT |
Returns a positive square root of a number. |
|
SUM |
Sums (adds) the set of numbers, including all numbers in a range. |
|
TAN |
Returns the tangent of a number in radians. |
|
TRIM |
Removes spaces from text; replaces all internal multiple spaces with a single space. |
|
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. |