finding previous day record
Hi,
I have a file of daily transactions where I find details of the latest record using Max date.
How can I find details of the previous days' transaction in order to compare it to the latest day?
I need to find out when a particular value for an account has changed from one day to the next - sometimes it doesn't change but I'm only interested when it does.
Record ID Date Bal Amount
10008 15 Aug 2021 13528.37
10008 16 Aug 2021 13440.28
10008 17 Aug 2021 13440.28
In the scenario above I would be interested in identifying the change between 15th and 16th Aug but not 16th and 17th Aug
Any help would be appreciated.
Thanks
Answers
-
Hi Gaz
(deleted my previous comment)
- filter for latest data and inverse filter for previous on Date column
- sort previous data newest to oldest
Then add a Transform step with an Advanced Function to Subtract Amount from PrevAmount and flag where not zero
0 -
Thanks for this Josh, much appreciated.
I will have a try and then flag progress - seems very logical.
1 -
Sorry, this one didn't work but your subsequent resolution to my issue did (posted as another issue).
Many thanks
0