Grand Total of schedule added to parameter

[hrogersF9RTD]

Hi All, 

Does anyone know a way to take the value in a grand total of a schedule, and populate it to a parameter?  As far as I can work out, that value doesn't exist anywhere else other than at the bottom of the schedule.

A bit of context:  I'm trying to take the grand total of weight for sheet metal in a schedule, and divide it by 40hrs to work out how many hours it'll take the shop to build that particular duct package.  I've successfully done that, but I'd like to get that value into a schedulable parameter, so that we can add it to the fabrication package in our fab tracking software.  

Any help anyone has would be much appreciated. 

[iainsavage]

Not what you are asking for but in the schedule you could create a calculated value which would show hours for each item and then get a grand total for that column?

Then you can export the schedule to a spreadsheet if you wish.

[L.Maas]

A Dynamo script could do the trick. Let Dynamo add up certain values and then write it to a shared parameter.

[iainsavage]

Ha, I was just about to suggest that too.

[RLY_15]

There's a trick you can do with the Total where you use the 1/[Percentage Of Total] calculated value to generate the Total. Unfortunately it doesn't work with tables that contain zero values (divide by zero error).

Which means you need a third-party approach (Excel data linking, Dynamo, etc.).