Displaying a Total That Siebel CRM Derives from an Expression in a Business Component Field

You can display a total that references an expression that is defined in a business component field. For example, the Revenue business component includes the following fields:

  • Quantity

  • Price

  • Calculated Revenue

The Calculated Value property of the Calculated Revenue contains the following expression:

[Quantity]*[Price]

You can display the following values in a list applet that references this business component:

  • Total quantity. The sum of all values in the quantity field.

  • Total revenue. The product of the totals of the quantity and price columns.

To display a total that Siebel CRM derives from an expression in a business component field

  1. In Siebel Tools, display the List Column User Prop child object type of the List object type.

    For more information, see Displaying Object Types You Use to Configure Siebel CRM.

  2. Make sure an expression is defined in the business component field that Siebel CRM maps to the list column.

  3. Make sure the Total Required property of the list column contains a check mark.

  4. In the Object Explorer, click Applet.

  5. In the Applets list, locate the applet you must modify.

  6. In the Object Explorer, expand the Applet tree, and then click List.

  7. In the Object Explorer, expand the List tree, and then click List Column.

  8. In the List Columns list, locate the column you must modify.

  9. In the Object Explorer, expand the List Column tree, and then click List Column User Prop.

  10. In the List Column User Props list, add a user property named TotalAsExpr.

    Adding this user property is sufficient to evaluate the totals as an expression. Siebel CRM ignores the properties of the field.

  11. Set the property attribute of the <div od-type="control"> tag in the template file to Total.

  12. Compile and test your modifications.

    For more information, see Using Siebel Tools.