Hi everyone.
Currently we have a list which includes the production figures for every hour. I have created a column at the end called running total in which I would like it to add up the previous entries and display the total figure so far.
I think I need to use the calculation field in SharePoint Designer 2013, but I am unsure how to do it.
So I want to get the data form a field called ‘Actual Number Made’ and display this number in the running total column but have the running total column add all previous entries together.
So it could look like
Actual Number Made – 3000Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Running Total – 11,000
Actual Number Made – 4000Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
Actual Number Made – 4000
I just give that a try and it is only showing from the current row and not the row above it. Do I need to add anything else in?
Thanks a lot for that Pankaj Srivastava. I will give it a try now:)
Hi Jonathan,
Calculated column would be the best option to archive your requirement create a Calculated coulmn Running Total and use =SUM[Actual Total Made]) formula.
