Views:

Description

Returns the average value of the 'outputfieldname' for the records specified by the input parameters.

e.g. Returns the average value of the Estimated Value field of all opportunities for a customer.

Signature

FindAvg('entitylogicalname', 'inputfieldname', 'inputfieldvalue', 'outputfieldname', 'defaultvalue', 'nolock', 'noagg')

Note: The parameters 'nolock' and 'noagg' are optional

Example

FindAvg('opportunity', 'customerid', [account.accountid], 'estimatedvalue', '0', false, false)
 

Parameters

Name Type Description Required
entitylogicalname xxxx xxxx xxxx
inputfieldname xxxx xxxx xxxx
inputfieldvalue xxxx xxxx xxxx
outputfieldname xxxx xxxx xxxx
defaultvalue xxxx xxxx xxxx

Notes: