<< Click to Display Table of Contents >> Navigation: Available Functions > LargestPlgFor() |
Syntax
LargestPlgFor( <Condition>, <PledgeExpr> )
Purpose
To retrieve information from the largest pledge in a donor's history.
Parameters
<Condition> is any expression that evaluates to true or false. Only pledges for which this condition is true will be considered when searching for the largest pledge.
<PledgeExpr> is the value you wish to retrieve from the largest pledge. It can be an expression of any data type, and it is normally the name of a pledge field.
Returns
The value of <PledgeExpr> for the largest pledge.
Usage
This function can be used to search donor history during a report or data export to retrieve information about the largest pledge in each donor's history.
Example
If you wish to retrieve the amount of the largest pledge made by each donor in calendar year 2017, you could use "LargestPlgFor()" in the following manner:
LargestPlgFor( Year( .Pledge_Start_Date. ) = 2017, .Pledge_Amount.)