Views:

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

Notes: