The correct answer is C. MPT.
The MPT function is used to calculate the maximum percentage of a value that is less than or equal to another value. This function is not typically used in calculated controls in a report, as it does not provide any meaningful information about the data.
The SUM, AVG, and COUNT functions are all commonly used in calculated controls in a report. The SUM function calculates the sum of a range of values, the AVG function calculates the average of a range of values, and the COUNT function counts the number of values in a range. These functions can be used to provide valuable information about the data in a report, such as the total number of items, the average value of an item, or the number of items that meet a certain criteria.
Here is a table that summarizes the functions and their uses:
| Function | Description | Use in calculated controls |
|—|—|—|
| SUM | Calculates the sum of a range of values | To calculate the total number of items, the total value of a group of items, or the total value of a range of items |
| AVG | Calculates the average of a range of values | To calculate the average value of an item, the average value of a group of items, or the average value of a range of items |
| COUNT | Counts the number of values in a range | To count the number of items, the number of items in a group, or the number of items in a range |
| MPT | Calculates the maximum percentage of a value that is less than or equal to another value | Not typically used in calculated controls in a report |