MaxF
MaxF function returns the maximum value out of a set of expressions and conditions.
Syntax :
MAXF(Expression,[Condition])| Parameters | Description |
|---|---|
| Expression | Column or Formula that will be used to search for the Maximum Value |
| [Condition] | [OPTIONAL] - Calculation to determine if row should be included |
Examples :
Table Name : Products
| ProductID | Product Name | Price |
|---|---|---|
| 1 | Pen | 6 |
| 2 | Pencil | 3 |
| 3 | Eraser | 2 |
| 4 | Bottle | 5 |
| 5 | Book | 10 |
| 6 | Marker | 12 |
| 7 | Sheets | 4 |
Example 1
dMaxF = MaxF(Price)
Debug(dMaxF)Result :
MaxF
= 12Example 2
dMaxF = MaxF(Price,ProductName<>'Marker')
DEBUG(dMaxF)Result :
dMax
= 10