Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

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

3 ANTWORTEN 3
Antworten
Nachricht 1 von 4
zohaib.zaman
1134 Aufrufe, 3 Antworten

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

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.

3 ANTWORTEN 3
Nachricht 2 von 4
ToanDN
als Antwort auf: zohaib.zaman

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.  

Nachricht 3 von 4
lucdoucet_msdl
als Antwort auf: zohaib.zaman

@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

Nachricht 4 von 4
RDAOU
als Antwort auf: zohaib.zaman

@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

 

RDAOU_0-1643712813456.png

 

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.

In Foren veröffentlichen  

Autodesk Design & Make Report