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
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.
User | Count |
---|---|
45 | |
29 | |
24 | |
21 | |
13 |