Trying to setup a MAXROW statement as per doc...

[Christian_Farl1]

Trying to setup a MAXROW statement as per documentation, as follows

MAXROW(Plateau,Date)

But this throws the following error:

Expression ‘MAXROW(Plateau,Date)’ could not be parsed due to exception: #VALUE!.

• Plateau is a table * Date is a Date column

Am I forgetting anything?

[Steven_Coile]

Try putting Date in quotes: MAXROW(Plateau, “Date”). Maybe it’s confused because Date is both the name of your column and a column type.

[Christian_Farl1]

Spot on! Thanks Steve