1. Personalization Administration Guide
  2. Math Functions

Math Functions

The following table lists the math function. See also 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 ([field_name], 'format')

Returns a string that represents a number or date in a format specified by the optional format parameter.

For example:

ToChar([Start Date], 'MM/DD/YYYY')

returns the starting date of a record as a string in MM/DD/YYYY format.

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.

To use the InvokeServiceMethod function in client mode, the business service name that is called by the InvokeServiceMethod function must be added as the BusinessServiceQueryAccessList parameter value under the [Siebel] section of the application configuration file as follows: [Siebel] BusinessServiceQueryAccessList = BusSvc1,BusSvc2,...Likewise, in Server mode, the component parameter BusinessServiceQueryAccessList must also be set to specify the list.

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.