Tableau Desktop Certified Associate: Exam Guide

Order of precedence of operators

The operators get evaluated in the following order of precedence:

1. – (negate)
2. ^ (power)
3. *, /, %
4. +, –
5. ==, >, <, >=, <=, !=
6. NOT
7. AND
8. OR

To change the order of precedence, we can use the final operator called parentheses, (). If you put something in parentheses, it gets executed first. If there are nested parentheses, then the innermost gets executed first and so on, for example, if we had the following expression to get evaluated: (1+2*5) = 11 , (1+(2*5)/2) = (1+10/2) =6.