Hi all.I need help. I am trying to calculate change in amount across a data set which has more than 1000 rows. I have attached a screenshot of input and output below for your reference. Basically, it is S.no. 2-1, 3-2 and so on. Please suggest a way.
S. No | Input | Output |
1 | 100 | 100 |
2 | 150 | 50 |
3 | 200 | 50 |
4 | 900 | 700 |
5 | 500 | -400 |
Solved! Go to Solution.
Hi @SCK
This can be easily accomplished by multi-row formula tool.
[Input]-[Row-1:Input]
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
Oh yeah, I figured out the way after i posted the question. Thanks for your help though! 🙂
Glad to hear 😀
Happy to help 🙂 @SCK
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂