Using a rate table with a formula rate
For our example, we set up rate #165, which is a weight-based secondary rate with a rate unit of dollars per ton. It also has a table of rates.
In the Expression Editor, we attached the following formula to the rate:
This illustration shows rate #165 applied to order #968, which has 20 tons recorded in the Weight field. From the rate table, the system selected the rate of $ 0.015, which is set up for 20 tons.
Weight | * | Billable Miles | * | Rate Factor | = | Calculated Rate |
20 tons | * | 104 miles | * | $ 0.015 | = | $31.20/ton |