Data calculation

[SCK]

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

[atcodedog05 · Accepted 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

[SCK]

Oh yeah, I figured out the way after i posted the question. Thanks for your help though! 🙂

[atcodedog05 · Accepted solution]

Glad to hear 😀

Happy to help 🙂 @SCK 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂