Displaying Totals in a Separate Applet

You can display totals in a separate applet. For example, Siebel CRM displays a form applet after a list in the Quote Details View. This form contains totals of columns that it displays in the list.

To display totals in a separate applet

  1. Create a form applet.

  2. Place the form applet after the list applet in the view.

  3. Create a field in the business component that the applet references.

  4. Add the following expression to the Calculated Value property of the business component field:

    Sum([multi-value field])
    
    Caution:

    Never define a Sum([multi-value field]) expression in a list column. This expression requires a separate query run for each record in the list. It can cause significant performance problems.

  5. In the business component, create a multi-value link.

  6. In the same business component, create a multi-value field that references the multi-value link.

    The multi-value link references the business component that supports the list of values that Siebel CRM sums.

  7. Compile and test your modifications.

    For more information, see Using Siebel Tools.