@RMAX

Calculate the maximum value for a row.

Syntax

@RMAX(t1, [nt2], [nt3])

Argument	Description
t1	A row code for the row to find the maximum. The row can be in the current or another spreadsheet. The string can be empty ("") to default to the base data cell of the current row.
nt	Optional. Start period name, number or column code for range to find the maximum. Default is the first period or column.
nt3	Optional. End period name, number or column code for range to find the maximum. Default is the last period unless processing the current row when it is assumed to be the column preceding the formula.

Argument

Description

A row code for the row to find the maximum. The row can be in the current or another spreadsheet. The string can be empty ("") to default to the base data cell of the current row.

Optional.

Start period name, number or column code for range to find the maximum.

Default is the first period or column.

nt3

Optional.

End period name, number or column code for range to find the maximum.

Default is the last period unless processing the current row when it is assumed to be the column preceding the formula.

Logic

The function finds the maximum of values in a spreadsheet row given a start and end column. The function ignores subtotal columns.

Examples

@RMAX("Row01", "Jan2023", "Mar2023")

@RMAX("", 1, 3)

@RMAX("Row01", 4)

@RMAX("Row01")