Value is the calculated cost for a transaction. The method of its calculation depends upon whether the behavior table row that is accessed by an assignment rule contains a unit value or a total value.
When a behavior-table row contains a unit value, the driver formula is used to calculate the number of units (driver quantity) involved in each transaction that is picked out by the selection criteria. Then, the cost for that transaction (Value) is determined by multiplying the number of units (driver quantity) by the unit cost (in the behavior table) of the transaction.
When a behavior-table row contains a total value, the driver formula is used to calculate the number of units involved (driver quantity) in each transaction that is picked out by the selection criteria. Then, the cost for that transaction is determined in the following way:
- The total number of units for all transactions (picked out by the selection criteria) is calculated by adding the number of units (as determined by the driver formula) for all the transactions picked out by the selection criteria.
That is, the total number of units is the sum of the driver quantities of the transactions picked out by the selection critera.
- The cost-per-unit is calculated by dividing the total value (in the behavior-table row) by the total number of units.
- The cost for each transaction (Value) is calculated by multiplying the cost-per-unit times the number of units (driver quantity) for that transaction.