How To Video: Create a Cost Rollup Using OpenBOM

Oleg Shilovitsky
Oleg Shilovitsky
20 December, 2024 | 2 min for reading
How To Video: Create a Cost Rollup Using OpenBOM

There is no single company in the world that will tell you that BOM cost is not important. However, when you ask how they perform cost calculations and estimations, the common answer involves spreadsheets, CSV files, or other manual methods. Surprisingly, even billion-dollar PLM product suites often fail to provide effective solutions for cost calculations.

At OpenBOM, we address this problem with a simple and effective cost rollup mechanism using OpenBOM formulas. This guide will walk you through the process step-by-step.

Learn Through a Video

In this video tutorial, you will learn how to perform a simple BOM cost rollup using OpenBOM’s formula mechanism. We will build on the BOM created in the previous lesson by adding calculated properties and formulas.

Watch the video – BOM Cost Rollup 

Step-by-Step Instructions

These are properties you need to perform a rollup, you need:

  1. A property to represent a “unit” value (e.g., “Cost”).
  2. A property to represent “Quantity” (used as a usage multiplier).
  3. A property to collect the rollup result (e.g., “Extended Cost”).

In this example, we use “Extended Cost” as the rollup property name, but you can customize it as needed. 

To create a formula, please follow these Step-by-Step Instructions

  1. Open Your Bill of Materials
  2. Access the BOM you created previously.
  3. Verify Required Properties
  4. Ensure the BOM includes both “Cost” and “Quantity” properties. These are typically default properties, so they are likely already present.
  5. Add the Rollup Property
  6. Add a new property to store the rollup result. For this example, name it “Extended Cost.”
  7. Enable the property across all sublevels by checking the “Include Sublevels” flag. If you skip this step, you’ll need to manually add the property to each sublevel later.
  8. Define the Rollup Formula
  9. Add a formula to the “Extended Cost” property:
    Extended Cost = Cost * Quantity
  10. Enable the rollup flag for this property.
  11. Once the formula is applied, the rollup values will be calculated automatically.

After the formula is added, verify you didn’t get any ERR messages in the BOM, which will indicate that something is wrong. Review the rollup values in your BOM. The “Extended Cost” property will display the aggregated cost for each item, taking into account the quantities specified.

For more information about cost rollup and other OpenBOM formula capabilities, please visit OpenBOM best practices documentation – advanced formulas. 

Conclusion

The OpenBOM rollup mechanism is a versatile tool that simplifies calculations for costs, weights, or any other values within your BOM. By using rollup formulas, you can efficiently manage complex data without relying on cumbersome manual methods.

Ready to streamline your BOM management? Register for free and discover how OpenBOM can transform your workflows!

Best regards,
Oleg

Related Posts

Also on OpenBOM

4 6
16 November, 2026

The best PDM is the one engineers barely notice. They open an assembly, do their work, and the files, revisions,...

16 November, 2026

A customer described reviewing every drawing before each release to me in four words: “Frankly, that’s a nightmare.” Brad Carpenter...

12 November, 2026

Open the drone’s BOM and it looks complete: frame, arms, motors, the motor mount you locked and changed last week....

10 November, 2026

You spend the afternoon reworking the motor mount for the drone. New hole pattern, thinner wall, everything fits. You save....

9 November, 2026

“Can we build 10 units by December 15?” It is a simple question. Answering it usually requires several people, several...

6 November, 2026

A picture worth thousands words. When we first built OpenBOM, customers told us “We love BOM with pictures”. It was...

5 November, 2026

“Can you send me the BOM and all the files?” It sounds like a simple request. Then someone starts exporting...

3 November, 2026

Learn item master management for growing manufacturers: separate item records, CAD files, BOM quantities, vendors, and ERP ownership in one...

3 November, 2026

Learn how strategic sourcing software can connect released product data, supplier quotes, and purchasing decisions without handing control to AI.

To the top