NEW – Multiple Rollups in OpenBOM 

Oleg Shilovitsky
Oleg Shilovitsky
4 July, 2019 | 2 min for reading
NEW – Multiple Rollups in OpenBOM 

When it comes to Bill of Materials, calculations is one of the most important things. Think about BOM as a recipe of what you need to do. How many materials and parts you need to buy and what do you need to order.

A simple way to organize calculations in OpenBOM is to create a formula that will take values of properties (eg. Cost and Quantity) and will calculate Total cost.

However, what happens when you need to calculate the cost of a component, which is an assembly and has subcomponent.

This is how we come to rollups – a feature that allows you to collect value for a specific property and roll it up to the upper-level assembly.

In OpenBOM you can organize rollups by setting up a special feature in Formula Editor. Also, please take a look on a new formula builder coming in the next release allowing you to edit formulas (many of you asked about it).

Once the formula is set, OpenBOM will perform the calculation.

In a new coming OpenBOM release, we are enhancing the functionality of rollups by allowing to support multiple rollups in the same Bill of Materials. It will eliminate some of the limitations (for example to rollup Cost and Mass at the same time).

In the video below, I will give you a short tour of new functionality. I hope you will like it.

Conclusion

OpenBOM rollup is a powerful feature, which allows you to organize calculation of values (in BOMs). It is flexible and can be used with any properties you define in a BOM. You need to set up formulas using formula builder. The new release brings multiple roll-up features, which is powerful because it will unlock many additional scenarios of calculations in Bill of Materials.

PS. Let’s get to know each other better. If you live in the Greater Boston area, I invite you for a coffee together (coffee is on me). If not nearby, let’s have a virtual coffee session — I will figure out how to send you a real coffee.

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website

Related Posts

Also on OpenBOM

4 6
5 September, 2025

In my recent article, OpenBOM Data Model (2025 Update): A High-Level Overview, I introduced the foundations of the OpenBOM Data...

4 September, 2025

In the last few weeks, we’ve been building in public and sharing the progress of OpenBOM BOM Excel MCP —...

3 September, 2025

We live in a digital world and data has become the most valuable business asset. Whether you are designing a...

29 August, 2025

Digital BOM is a foundation of all OpenBOM to ERP integrations. From the very early days of PLM, the connection...

28 August, 2025

In 2025, the push for better design-to-manufacturing integration is stronger than ever. But for many companies, this still gets reduced...

27 August, 2025

For decades, PDM meant file vaults, check-in/check-out, and revision control. But today’s products span mechanical, electronic, and software domains, with...

26 August, 2025

This article is part of OpenBOM BOM Excel MCP building in public. For the next few weeks, we are going...

22 August, 2025

In yesterday’s article – Understanding OpenBOM’s Multi-Tenant Data Model and System Configuration, I shared some insights about OpenBOM’s multi-tenant data...

21 August, 2025

In today’s manufacturing and engineering world, the term multi-tenant triggers both questions and confusion. Product Lifecycle Management (PLM) has historically...

To the top