The MAXA function returns the largest value in a column considering numbers, dates, and Booleans.
Syntax
MAXA(
column
)
Parameters
- column: Name of the column from which you want to extract the highest value.
Returned value
The MAXA function returns a scalar.
Additional Information
The function considers the following types of values:
- Numbers.
- Dates.
- Logical values (True evaluates to 1 and False to 0).
Empty cells are ignored. If the column does not contain values that can be considered, the MAXA function returns 0.
If you want to get the highest value from a column that contains texts, you should use the MAX function.
Examples
The following example calculates the maximum value of customer revenue:
Max Yearly Income = MAXA(Customer [YearlyIncome])
Category
Statistical