How Do I Combine Calculated Totals From Different Schedules?

[rchapmanCP]

I am totaling the volumes of concrete in footings and foundations used in a structural model, and the model has some elements modeled as "Structural Framing (other)", and "Structural Foundations".

Because they are two different elements, I have to create two separate schedules, a Structural Framing schedule, and a Structural Foundation schedule.

Perhaps the modeler could have been more judicial in modeling all foundation elements with the "Structural Foundation" family, but is there a way to take the Grand Total Volume from the "Structural Framing (other)" schedule, and add it to the Grand Total Volume from the "Structural Foundation" schedule?

It's only two numbers, so I can add them together via a calculator, but I am wondering what a workflow/workaround would be to combine values that are scattered about in different schedules (calculating total volume of all concrete used in a job? Columns, beams, slabs, all are specific and separate schedules so it's too constrained and siloed)

[ToanDN]

Create parts and schedule parts material take-off.

[vitorbortoncello · Accepted solution]

You can create a multi-category schedule that includes both "Structural Framing" and "Structural Foundations." You can add the Volume field to the schedule but you might need to use Shared Parameters if they aren't listed directly.