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
16 May, 2025

“You can take the engineer out of Excel… but you can’t take Excel out of the engineer.” This phrase captures...

14 May, 2025

No one wakes up in the morning and says – I need to buy some software. It is a problem...

10 May, 2025

We’ve all heard the saying: “It’s all about the data.” But here’s the real question in 2025: Which data? And...

9 May, 2025

Engineering data is not just about parts—it’s about relationships. What is this part? Where is it used? How is it...

8 May, 2025

At OpenBOM, we believe that technology is only half the story. The other half is people—local experts who understand your...

7 May, 2025

Most PLM systems were built for a different era—when engineering teams worked under one roof and product data was mostly...

5 May, 2025

In a few weeks, I’ll be traveling to Jerez de la Frontera in Andalusia to attend the Share PLM Summit....

2 May, 2025

Data is everything in today’s digital world. While every manufacturing company thinks differently about their products and strategy, the common...

1 May, 2025

Welcome to the April 2025 edition of What’s New in OpenBOM! Each month, we work hard to turn your feedback...

To the top