OpenBOM 101 – Formula and Calculations

Oleg Shilovitsky
Oleg Shilovitsky
16 May, 2019 | 1 min for reading
OpenBOM 101 – Formula and Calculations

Formulas in OpenBOM are equations you create in a cell which performs simple arithmetic operations using the designated cells.  The basic principle to understand is that a formula equation is in the usage of properties as parameters for the formula. The formula is always defined in the context of a specific line (Item).

So if you have a BOM like this one.

A simple formula calculating Ext Cost based on quantity and formula.

The second type of simple formulas in OpenBOM is called rollup. The property to define rollup is in the bottom of the grid. You can enable it by selecting the menu – Enable Totals. Rollup value will show up. You can edit formula for rollup as well.

The following video gives you an idea how it can work.


OpenBOM formula and calculation is a powerful yet very flexible mechanism to do a very basic, but important calculation based on these formulas.

You can try formula by registering to FREE OPENBOM USER account.

Best, Oleg

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
14 June, 2024

The Bill of Materials (BOM) serves as a key component of the manufacturing process. The BOM is a comprehensive list…

14 June, 2024

Change is the only constant thing you can see in every engineering and manufacturing process in your organization. Despite the…

13 June, 2024

In every manufacturing business, cost is a critical factor that can determine success or failure. Efficient cost management is essential…

12 June, 2024

In today’s fast-paced manufacturing environment, companies are increasingly seeking ways to work in a more connected and efficient manner. The…

11 June, 2024

In my previous article, I briefly introduced you to upcoming OpenBOM enhancements related to product structure management and the introduction…

8 June, 2024

In the modern manufacturing and supply chain management environment, streamlining processes from engineering to procurement is vital. To support customer…

7 June, 2024

The common story is for manufacturers to outsource production overseas to take advantage of lower costs amongst other things. At…

6 June, 2024

One of the questions that often causes confusion in product development and manufacturing is change management. This topic has many…

5 June, 2024

The last two decades of SaaS development have changed the way customers are buying software. What was before a lengthy…

To the top