LargestDonFor()

<< Click to Display Table of Contents >>

Navigation:  Available Functions >

LargestDonFor()

Syntax

LargestDonFor( <Condition>, <DonationExpr> )

 

Purpose

To retrieve information from the largest donation in a donor's history.

 

Parameters

<Condition> is any expression that evaluates to true or false. Only donations for which this condition is true will be considered when searching for the largest donation.

 

<DonationExpr> is the value you wish to retrieve from the largest donation. It can be an expression of any data type, and it is normally the name of a donation field.

 

Returns

The value of <DonationExpr> for the largest donation.

 

Usage

This function can be used to search donor history during a report or data export to retrieve information about the largest donation in each donor's history.

 

Example

If you wish to retrieve the amount of the largest donation made by each donor in calendar year 2017, you could use "LargestDonFor()" in the following manner:

 

LargestDonFor( Year( .Donation_Date. ) = 2017, .Donation_Amount.)