OpenBOM 101: Formulas, Calculations, Rollups

Oleg Shilovitsky
Oleg Shilovitsky
20 November, 2020 | 2 min for reading
OpenBOM 101: Formulas, Calculations, Rollups

In my article today, I will give a quick introduction to OpenBOM calculations and formulas. It is a powerful mechanism, which allows you to perform flat and structured calculations. Examples of calculations – to calculate a total cost of inventory, calculation total mass or total cost of the BOM. Another example of the calculation is to calculate the unit cost based on the purchased material length. There are other examples. Learn more about formulas and cost in our online training library.

Formula Builder

Formula builder allows you to create a formula. You can type the names of the processes (instead of cell numbers like in Excel or Google Sheet).

openbom formula builder

Line Calculations 

All OpenBOM formulas are applied to a specific line in a BOM or Catalog or to all lines. The formula includes names of properties and operations. The scope of the line formula is in the single line.

Structure Calculations (or Rollups)

The calculation with the scope goes between lines is called rollup. In such a case OpenBOM applies all calculations in a specific level (eg. sub-assembly) and the total cost of the sub-assemblies applies to the upper “unit cost” level. In such a case, OpenBOM can calculate different values (eg. cost, mass, etc.) and make totals for the BOM. 

This is the simplest calculation available in OpenBOM – Totals. It can be done in any table and it includes automatically sum of all line values.

In the following two videos I will demonstrate the use of both formulas. I will use line calculation and flat totals in the catalog. Here is the video. 

The following video shows how formulas can be applied in the structure. In the video I demo how you can create a cost rollup and apply it to all BOM levels. 

Conclusion

OpenBOM calculations and formulas is a super powerful tool that can simplify your life when making calculating in BOMs, Catalogs, Order BOMs for many engineering and procurement use cases. Learn more about it in our Online Training Library.

Try OpenBOM today. Register for FREE here.

Best, Oleg @ openbom dot com.

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website. Read OpenBOM customer reviews on G2 Crowd to learn what customers are saying about OpenBOM. 

Related Posts

Also on OpenBOM

4 6
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...

20 August, 2025

Since the very beginning of OpenBOM, our mission has been to help engineers, manufacturers, and teams organize product information and...

19 August, 2025

There is a need for a rich and structured context.  Artificial intelligence has quickly become the buzzword in every boardroom,...

15 August, 2025

A recent post by Martijn Dullaart on LinkedIn about Product Changes caught my attention. Here is the link to the...

To the top