The following table lists the formula operators used by Report Writer/Mass Load.
|
Operator |
Description |
Example |
|
+ |
Add |
4+5, adds the value in column 4 to the value in column 5. |
|
- |
Subtract or negation |
4-5, subtract the value in column 5 from the value in column 4. -5, a negative value. |
|
/ |
Divide |
4/5, divide the value in column 4 by the value in column 5. |
|
* |
Multiply |
4*5, multiply the values in columns 4 and 5. |
|
" or '
|
Constants |
"4" + "5" = 9 '4' + '5' = 9 When numeric values are enclosed in double quotes (") or single quotes ('), the actual numeric value, as opposed to the column number, is being referenced. |
|
( ) |
Change the order of evaluation. |
2*(3+4) is interpreted as 2*7=14 (2*3)+4 is interpreted as 6+4=10. |
See Also: