Forum Discussion

ntaylo06's avatar
ntaylo06
Resolver II
7 years ago
Solved

Getting Data From Previous Row Based On Two Criteria

I have have the table 'Data' with the fields 'employee ID', 'rotation number', and 'location' with each employee ID appearing three times with rotation number increasing each time and a location code...
Need Help
  • ntaylo06's avatar
    ntaylo06
    7 years ago

    HotChilli Thats alright, I found a workaround solution by adding an index column and then calculating index-1 from it. Thanks for trying, though.

ntaylo06's avatar
ntaylo06
Resolver II
7 years ago

HotChilli Thats alright, I found a workaround solution by adding an index column and then calculating index-1 from it. Thanks for trying, though.

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

ntaylo06 

 

Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.