Mapistry’s formula builder provides more advanced calculation options beyond addition, subtraction, multiplication, and division. See more advanced functions below.
Common Operators:
Assume x and y represent variables which your own field tokens and values will replace.
| Symbol | Alternate Equivalent Function | Operation |
| + | add(x,y) | Add two or more values, x + y |
| - | subtract(x,y) | Subtract two values, x - y |
| * | multiply(x,y) | Multiply two or more values, x * y. |
| / | divide(x,y) | Divide two values, x / y |
| () | Parentheses. Set the order of operations. | |
Assume a, b, c, x, and y represent variables that your own field tokens and values will replace.
| Symbol | Description |
|
pow(x,y) Alternatively, use the symbol “^” |
Calculates the power of x to y, x ^ y |
| abs(x) | Calculate the absolute value of a number x. |
| square(x) | Compute the square of a value, x * x. |
| sqrt(x) | Calculate the square root of a value. |
| cube(x) | Compute the cube of a value, x * x * x. |
| log10(x) | Calculate the 10-base logarithm of a value x. |
| log(x,y) | Calculate the logarithm of a value x with logarithm base y. |
| factorial(x) | Compute the factorial of a value. Factorial only supports an integer value as an argument. |
| max(a,b,c,…) | Compute the maximum value of a list with values. |
| min(a,b,c,…) | Compute the minimum value of a list with values. |
| mean(a,b,c,…) | Compute the mean of a list with values. |
| median(a,b,c,…) | Compute the median of a list with values. |
| mode(a,b,c,…) | Compute the mode of a list with values. |
| sec(x) | Calculate the secant of a value. |
| sin(x) | Calculate the sine of a value. |
| tan(x) | Calculate the tangent of a value. |
| % | Divide by 100. |
Comments
0 comments
Please sign in to leave a comment.