Description
Returns the maximum value of the 'outputfieldname' for the records specified by the input parameters.
e.g Returns the value of the max estimatedvalue of all opportunities for a customer.
Signature
FindMax( 'entitylogicalname', 'inputfieldname', 'inputfieldvalue', 'outputfieldname', 'defaultvalue', 'nolock', 'noagg' )
Example
FindMax( '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 |