Views:

Description

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

e.g. Returns the value of the minimum Estimated Value field of all opportunities for a customer.

Signature

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

Note: The parameters 'nolock' and 'noagg' are optional

Example

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

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: