Jump to content
  • 0

Row or Record Number after report sorting



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.


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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...