Applying user-defined formulas to billing rates > Using a rate table with a formula rate
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