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.
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.
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.
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
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
If you need more help upload/attach the dynamo graph you are using
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.