FindSum

Description

Returns the Sum of the 'outputfieldname' for the records specified by the input parameters.

Signature

FindSum(
  'entitylogicalname', 
  'inputfieldname',
  'inputfieldvalue',
  'outputfieldname',
  'defaultvalue', 
  'nolock',
  'noagg'
)

Example 1

e.g. Returns sum of all opportunities for a customer using the Estimated Value field.

FindSum(
  'opportunity',
  'customerid',
  [account.accountid], 
  'estimatedvalue',
  '0',
  false
)

Example 2

e.g. Returns sum of all opportunities for a customer, using the Estimated Value field, with the last parameter is set to true so it will not use aggregate FetchXML when performing the query. 

FindSum(
  'opportunity',
  'customerid',
  [account.accountid], 
  'estimatedvalue',
  '0', 
  false,
  true
)