Calculations & Formulas
Last updated
Was this helpful?
Last updated
Was this helpful?
User can enter a formula by clicking the formula input box. Whatever is entered in the formula input box will be saved in the format $fn{formula}. The formula can contain constants, variables, operators, and functions.
+, -, *, /, % (modulus), ^ (exponent) -> + works with strings and numbers while others will work with numbers only
| (pipe) can be used to pass the result of the left-hand side expression as the first argument of the right-hand side expression.
User's can view all the supported functions by typing '@'. The supported functions are
Number Functions
@sum([n1, n2, …]): Calculates the sum of the given numbers or variables.
@max([n1, n2, …]): Finds the maximum value among the given numbers or variables.
@min([n1, n2, …]): Finds the minimum value among the given numbers or variables.
@mean([n1, n2, …]): Calculates the mean (average) of the given numbers or variables.
@median([n1, n2, …]): Finds the median value among the given numbers or variables.
@abs(n): Returns the absolute value of the given number or variables.
String Functions
@trim(str, chars): Removes specified characters from the start and end of a string.
@trimPrefix(str, prefix): Removes a specified prefix from the start of a string.
@trimSuffix(str, suffix): Removes a specified suffix from the end of a string.
@upper(str): Converts a string to uppercase.
@lower(str): Converts a string to lowercase.
@split(str, delimiter, n): Splits a string into an array of substrings based on a specified delimiter, with an optional limit on the number of splits.
@splitAfter(str, delimiter, n): Splits a string into an array of substrings based on a specified delimiter, with an optional limit on the number of splits, and includes the delimiter in each substring.
@replace(str, old, new): Replaces occurrences of a specified substring with a new substring in a string.
@repeat(str, n): Repeats a string a specified number of times.
@indexOf(str, substring): Returns the index of the first occurrence of a specified substring in a string.
@lastIndexOf(str, substring): Returns the index of the last occurrence of a specified substring in a string.
Type Conversion
@type(v): Returns the data type of the value 'v'.
@int(v): Converts the value 'v' to an integer.
@float(v): Converts the value 'v' to a floating-point number.
@string(v): Converts the value 'v' to a string.
@toJSON(v): Converts the value 'v' to a JSON string.
@fromJSON(v): Converts the JSON string 'v' to its corresponding value.
Miscellaneous
@len(v): Returns the length of an array or string
