Description
Returns the average value of the 'fieldname' for the records specified by the FetchXML.
e.g. Returns the average value of the Estimated Value field of all opportunities for a customer.
Signature
FindAvgFD( 'formuladetailname', 'fieldname', 'defaultvalue', 'nolock', 'params', 'noagg' )
Note: The parameters 'nolock', 'params' and 'noagg' are optional
Example
FindAvgFD(
'OpenOpportunities',
'estimatedrevenue',
'0',
false,
SetParams('param1', 'param2'),
false
)
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| formuladetailname | xxxx | xxxx | xxxx |
| fieldname | xxxx | xxxx | xxxx |
| defaultvalue | xxxx | xxxx | xxxx |