Jump to content

Is it possible to find difference between previous record and next record in a single calculated column


Kaaviya Nehe

Recommended Posts

I have a table which has data for 2018and 2019for a particular category. I need to find the difference between 2019 and 2018 if 2019 filter is selected and if 2018 is selected the difference should show 0, but if I get data for 2017 then again it should show the difference. I need to get this in one column as I have to use it for trellis. Please let me know if there are any suggestions.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...