Get the sum of one parameter (e.g. length) at the end in a similar column when parameter's data is successfully exported to Excel through dynamo

[zohaib.zaman]

Hi everyone.

I have successfully got all the lengths of top-rail in Excel through a dynamo script. Now I want the total sum of lengths in the last cell of the similar column (i.e., length column) in excel. Is there any way of doing it so as I have also attached the ss for better understanding? 

thanks in advance.

[ToanDN]

If you want the total length in the Revit Schedule then Format the Length field and select calculate Totals

Or if you just want it in Excel then use SUM function in Excel.  

[lucdoucet_msdl]

@zohaib.zaman 

---

Now I want the total sum of lengths in the last cell of the similar column (i.e., length column) in excel. I

---

If you are also exporting the lengths to the Excel file, I would suggest you create your sums in the excel file.
If not, or for some reason the totals are hard to organise in Excel, you can easily calculate sums as a new list and export those values in Excel cells as required.

---

Is there any way of doing it so as I have also attached the ss for better understanding? 

There doesn't seem to be a file attached to your posting.

As this question seems to pertain more to the Dynamo than the Revit part of the solution, I would suggest you also post this question in the Dynamo Forum, if you don't get the solution here.

Dynamo Forum

So post your dynamo script and/or send an image export / screen capture of the script to enable us to understand where you are at.

-luc

[RDAOU]

@zohaib.zaman 

Unless the length of the top rails is not similar to that of the Railing element itself, you can basically add grand total and go to FIle Menu >> Export >> export schedules to Excel without dynamo.

If you want to do it in Dynamo...you will need a 2 nodes after the GetParametervalue and before you write to Excel

• Math.Sum 
• List.AddItemtoEnd

If you need more help upload/attach the dynamo graph you are using