How Data Type Affects Order of Precedence

If the Calculated Value property references more than one field value, and if these fields use different data types, then the order of the data types can affect the calculation. For example, the Quote Item business component includes the Line Total calculated field. This field uses the following calculated value:

[Item Price] * [Quantity]

where:

  • The data type of the Item Price field is DTYPE_INTEGER.

  • The data type of the Quantity field and the Line Total field is DTYPE_CURRENCY.

In this example, if Item Price is 2.25, and if Quantity is 5, then Siebel CRM sets the Line Total to 11.25.

Assume you modify the calculated value of the Line Total field to the following:

[Quantity] * [Item Price]

In this example, if Item Price is 2.25, and if Quantity is 5, then Siebel CRM sets the Line Total to 11.00.