Section Topics
Calculating a Maximum Value
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:
Stagnant Contacts Report
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
Using Max in the InterAction Report Designer
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 Reports that Use Max
Following are InterAction out-of-the-box reports that use Max:
| Report | Field Counted |
|---|---|
| Stagnant Contacts | Start_Date (Activity Start Date) |
