Hello,
I have a script that creates a dailyexport.csv that looks like this:
Date, Total
10/10/2017, 5000
10/11/2017, 6300
10/12/2017, 8200
I would like to import the csv file above, then add another column called "DailyTotal" and then script the calculation for "DailyTotal". Then output the .csv to a new.csv would look like this.
Date, Total, DailyTotal
10/10/2017, 5000
10/11/2017, 6300, 1300
10/12/2017, 8200, 1900
I've searched for answers but can't seem to find anything where a calculation is performed on a cell value from the previous line. Any help would be greatly appreciated!
Daryl