Views:

Description

Returns the Sum of the 'fieldname' for the records specified by the FetchXML.
 

Signature

FindSumFD('formuladetailname', 'fieldname', 'defaultvalue', 'nolock', 'params', 'noagg')

Example 1

Returns sum of all opportunities for a customer using the Estimated Revenue field.

FindSumFD('OpenOpportunities', 'estimatedrevenue', '0', false, SetParams('param1', 'param2')) 

Example 2

Returns sum of all opportunities for a customer using the Estimated Revenue field. The last parameter is set to true so this query will not use aggregate FetchXML when performing the query.

FindSumFD('OpenOpportunities', 'estimatedrevenue', '0', false, SetParams('param1', 'param2'), true)

Parameters

Name Type Description Required
formuladetailname xxxx xxxx xxxx
fieldname xxxx xxxx xxxx
defaultvalue xxxx xxxx xxxx

Notes: