The Max function returns the maximum value for a field. For example, you can use Max to include the most recent activity or appointment for a contact.
The InterAction out-of-the-box Stagnant Contacts report is a good example of Max. It displays the most recent activity for a contact:
To find the maximum value for a field, select the textbox in the Report Designer and then set the following values for that textbox:
- Set SummaryFunc to Max
- Set SummaryRunning to Group
- Set SummaryType to SubTotal
- Set the DataField property to the field for which you want to find the maximum value
How Do I Fiind the Minimum Value for a Field?
Similar to the Max function, you can use the Min function to find the minimum value for a field.
To find the minimum value for a field, select the textbox in the Report Designer and then set the following values for that textbox:
- Set SummaryFunc to Min
- Set SummaryRunning to Group
- Set SummaryType to SubTotal
- Set the DataField property to the field for which you want to find the minimum value
InterAction Out-of-the-Box Reports that Use Max
| Report | Field Counted |
|---|---|
| Stagnant Contacts | Start_Date (Activity Start Date) |