Calculations may be performed between numeric export choices. Type the calculation symbols in the Length column. Type a + symbol in the Length column for the Field Name on which the calculation is being performed. Add a Literal to insert a blank column for totals.
The following calculations can be performed:
| SYMBOL | FUNCTION |
| + | Add |
| - | Subtract |
| X | Multiply |
| / | Divide |
| = | Equals the results of the previous field calculation.* Review the information on Scale Editing Numeric Fields. The export choice line must be blank when using = for the function to export the results of the calculated fields. |
* Scale Editing Numeric Fields
In the example below, the Price is subtracted from the Rx Cost and then the Markup is subtracted. The Total is calculated and formatted to contain three positions to the right of the decimal: