Views:

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)

Parameters

Name Type Description Required
entitylogicalname xxxx xxxx xxxx
inputfieldname xxxx xxxx xxxx
inputfieldvalue xxxx xxxx xxxx
outputfieldname xxxx xxxx xxxx
defaultvalue xxxx xxxx xxxx

Notes: