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 |