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

expressions
(Christian Farley) #1

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) #2

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 Farley) #3

Spot on! Thanks Steve