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
21 February, 2024

I haven’t had a chance to meet a manufacturing company that was not interested in cost analysis or cost management….

20 February, 2024

I’m excited to share with you the latest updates to OpenBOM. But before we delve into the details, I want…

17 February, 2024

Despite the widespread adoption of digital technologies like computers, mobile devices, the internet, and various digital services, Excel continues to…

16 February, 2024

Dealing with mistakes made by suppliers is a crucial aspect of managing manufacturing processes and ensuring product quality and timely…

16 February, 2024

In the rapidly evolving landscape of modern product development, the complexity and need for collaboration are at an all-time high….

14 February, 2024

Bill of Materials (BOM) management is an essential component of product development, manufacturing, and supply chain management processes. These processes…

13 February, 2024

Newton, MA  – OpenBOM, a leading provider of cloud-based PDM and PLM software helping manufacturing companies to manage their digital…

9 February, 2024

Data is one of the most valuable assets for any product development and manufacturing company in the world. Unfortunately, for…

9 February, 2024

As a manufacturer, sharing product data with your contract manufacturer (CM) or supplier is one of the most important and…

To the top