I'm new to caspio and have been searching for a solution to find the value in the previous row on a report that has been filtered and sorted so I can add it to the current record.
I know there is an option to include the Record Index in the report but can't find out if that can be used in a calculation. I have also looked at LAG() as well as ROW_NUMBER() but can't get either to work.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
zacstar
Hi All,
I'm new to caspio and have been searching for a solution to find the value in the previous row on a report that has been filtered and sorted so I can add it to the current record.
I know there is an option to include the Record Index in the report but can't find out if that can be used in a calculation. I have also looked at LAG() as well as ROW_NUMBER() but can't get either to work.
Is there any other function I could use?
Thanks in advance.
Stephen
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.