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 |