Forum Discussion
Grouping / Aggregation
I have the data below and was wondering how to calculate the diff column which is previous qty minus current row quantitiy while ensuring ID is the same. Many thanks! ID RecordDate Accumila...
Anonymous this looks like exactly what I'm looking for. Ill try it out when i get the chance and report back/accept as soution. Many Thanks!
edit. Actually, this wouldnt work if I had an id of 4 in the same dataset as the id of 5 would it?
Matt_P
This formula is created by looking at the the index column, so it does not matter if your ID is 4 or 5.
Just leave a message for any updates if needed.
Best,