| Operators |
The following describes the different operators available in the Tabs3 Report Writer:
| Addition + | An arithmetic operator permitting addition. |
| Subtraction - | An arithmetic operator permitting subtraction. |
| Multiplication * | An arithmetic operator permitting multiplication. |
| Division / | An arithmetic operator permitting division. |
| Percentage % | An arithmetic operator that multiplies a number by 100 and then places a percent sign after the new number. For example, the calculation of 100/500 equals ".20". Applying the percentage arithmetic operator to the formula will display the result as "20%". The formulas "100/500%" and "(100/500)%"will both yield the same results. Percentages are rounded to the nearest hundredth of a percentage. For example, ".18767%" would become "18.77%". |
Note: If a multiplication or division operator is used in a formula column that is totaled, then the total is calculated according to the formula. For formula columns that do not use a multiplication or division operator and are totaled, the total is calculated as a "running" total.