Im trying to get the last most recent row dat...

(ravid shechter) #1

Im trying to get the last most recent row data for some calculation, So i tried to create a ref by

MAXROW(table name, column name), and set the column as virtual and as Ref, with and without filter conditions, as I saw that the example is doing… https://www.appsheet.com/Template/AppDef?appName=Data-210414&nonce=1902786010#Data.Columns

BUT i get this " could not be parsed due to exception: #VALUE!" when I try to verify the formula. WHY??? any suggestions? please help, im stuck

(Steven Coile) #2

What is the exact MAXROW() expression you’re using? I’m guessing it includes an unquoted textual value that has a special meaning deep in AppSheet’s guts. Try quoting both the table and column names.