Bookshelf Home | Contents | Index | PDF

## Math Functions

Table 38 lists the math function. See also Functions.

Table 38.  Math Functions
Function
Description

Sum (mvfield)

Sums the values from a field in child records.

You must define the child record that is being summed from as a multivalue field that is part of a multivalue group. The multivalue group is associated with the business component of the field that is being summed.

For example:

Sum ([Number of Employees])

gives the sum of all the employees at different locations for a company.

Count (mvfield)

Returns the number of rows in the multi-value group defined by the mvfield.

For example:

Count([Number of Employees])

gives the number of employees at different locations for a company.

ToChar (number, format)

Returns a string that converts a number to a format specified by the format parameter. For details on the supported formats, see Using Siebel Tools.

For example:

ToChar (10, "##.##")

returns "10.00".

Min (mvfield)

Returns the minimum value from a field in child records.

You must define the child record being examined as a multivalue field that is part of a multivalue group. The mutlivalue group is associated with the business component of the field being evaluated.

For example:

Min ([Number of Employees])

gives the minimum number of employees of all the locations.

Max (mvfield)

Returns the Maximum value from a field in child records.

You must define the child record being examined as a multivalue field that is part of a multivalue group. The mutlvalue group is associated with the business component of the field being evaluated.

For example:

Max ([Number of Employees])

gives the maximum number of employees of all the locations.

InvokeServiceMethod (name, method, context, returnProperty)

Returns the value of the return property from the returnProperty set of the specified business service, after invoking the method with the context.

For example:

InvokeServiceMethod ("BusServ", "PersonalizationMethod", "Key1=a,Key2=2", "ReturnProperty")

invokes the business service method PersonalizationMethod in business service BusServ, passes it the context Key1=a,Key2=2, and returns the value set by the business service in the property ReturnProperty.

LN (num)

Returns the natural log of the num.

For example:

LN (10)

returns 2.30.

GetNumBCRows (BO, BC, search_expr, visibility)

Returns the number of rows business component BC has, which is part of business object BO, after applying the search_expr and visibility.

For example:

GetNumBCRows ("Contact", "Contact", "A*", "Organization")

returns the number of rows that match the criteria.

 Siebel Personalization Administration Guide