The familiar rules of precedence – multiplication and division before addition and subtraction –- apply for arithmetic operators. The "Modulo" operator is evaluated first followed by multiplication/division ("*" and "/") and finally addition and subtraction ("+" and "-"). Example: NET_PRICE+(NET_PRICE*0.19)
Operator | Meaning | Data types |
|---|---|---|
+ | Addition | string, date, number |
- | Subtraction | date, number |
* | multiplication | number |
/ | Division | number |
% | modulo (remainder with division) | number |