Tableau supports numerous functions and operators. In addition to the functions that are listed on the calculation screen, Tableau supports the following operators, key words, and syntax conventions:
- AND: Logical and between two Boolean (true/false) values or statements
- OR: Logical or between two Boolean values or statements
- NOT: Logical not to negate a Boolean value or statement
- = or ==: Logical equals to test equality of two statements or values (single or double equal signs are equivalent in Tableau's syntax)
- +: Addition of numeric or date values or concatenation of strings
- -: Subtraction of numeric or date values
- *: Multiplication of numeric values
- /: Division of numeric values
- ^: Raise to a power with numeric values
- (): Parenthesis to define order of operations or enclose function arguments
- []: Square brackets to enclose field names
- {}: Curly braces to enclose level of detail calculations
- //: Double slash to start a comment
Field names that are a single word may optionally be enclosed in brackets when used in calculations. Field names with spaces, special characters, or from secondary data sources must be enclosed in brackets.