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.

Conclusion.

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
11 July, 2025

If you work in manufacturing or procurement, you already know the struggle. You need STEP files for CNC programming, PDF...

10 July, 2025

We are excited to share that OpenBOM now offers a completely revamped integration with QuickBooks, bringing your engineering, inventory, and...

9 July, 2025

A few days ago, I posted an article titled Is your data BOMable?, where I explored the readiness of your...

8 July, 2025

Let’s be honest – keeping track of accurate Bills of Materials (BOMs) is one of the biggest challenges in engineering...

3 July, 2025

Walk into any engineering office today, and you’ll see it immediately: Excel open on someone’s screen. Spreadsheets have been the...

2 July, 2025

Engineers rarely build entirely new products from scratch. Whether designing machinery, electronics, or high-tech projects, most products are evolutions of...

1 July, 2025

At OpenBOM, our vision has always been clear – to create an open and flexible information model, built using modern...

30 June, 2025

At OpenBOM, we know that managing changes is one of the most critical – and often challenging – aspects of...

27 June, 2025

At OpenBOM, we talk to manufacturing companies of all sizes – startups, mid-sized innovators, and established enterprises, and most of...

To the top