FindSumFD

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
)