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.