New Formulas Option – Conditional Rollup

Oleg Shilovitsky
Oleg Shilovitsky
14 December, 2020 | 2 min for reading
New Formulas Option – Conditional Rollup

The formula is a powerful mechanism in OpenBOM, which allows you to perform various calculations. OpenBOM supports formulas in both catalogs and BOMs. These formulas have different purposes and can be applied differently. 

Catalog formulas are useful to make calculations on a single item (eg. unit of measurement, cost, etc) and on an entire catalog (eg, cost of inventory). The last one is done using the catalog formula totals function. Bill of Materials formulas are more advanced and allow you to perform simple calculations with each BOM item line, but also to perform totals and rollup calculations. 

The rollups are the most sophisticated because they are making calculations for the product structure (hierarchy) and capable to roll up totals from the lower level of BOM up for all levels. Read more about OpenBOM formulas in our online training library here.

In the last OpenBOM update, we introduce a new option in the rollup calculations – conditional rollups. Think about a multi-level assembly, which uses some sub-assembly you plan to purchase from the external contractors. A typical example would be a pump or electric motor, but I’m sure you can come with many others. At the same time, you have a 3D model of the product with this “purchased assembly” and you need its parts to be in the BOM because of different reasons (eg. mass, compliance, and others). Let’s say I need to run a cost calculation, but I want to rollup the formula stop under certain conditions. It is hard to define these conditions upfront, but thanks to OpenBOM flexible data model, you define a property that can say, it is a purchased assembly or a normal assembly. 

Things can be implemented in a very simple way. You can introduce any property (eg. Item Type) with a value that will become criteria to stop a roll-up calculation. In my example, the “Purchased” value is a criterion, but you can define your own. 

Conclusion 

OpenBOM conditional rollup is the next step in the improvement of the calculations process that can be applied to product structure. It brings an additional level of flexibility for setting mixed options of purchased and manufactured products as well as any other rule-based calculations. 

Check what OpenBOM can do for you by registering FOR FREE and starting a 14-days trial for any OpenBOM subscription here.

Best, Oleg @ openbom.com

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website. OpenBOM can help you increase business productivity and reduce service cycles, product development cycles, and marketing life cycles. Just check our services and solutions that offer a robust foundation for startups and large companies. Read OpenBOM customer reviews on G2 Crowd to learn what customers are saying about OpenBOM. 

Related Posts

Also on OpenBOM

4 6
22 November, 2024

I’d like to share the story of xLM Solutions, a PLM service provider that focuses on helping businesses adapt and...

21 November, 2024

Manufacturing faces mounting challenges as product complexity grows, demanding advanced design and production capabilities to stay competitive. Cost pressures and...

20 November, 2024

In this article, we explore the story of Xtend AI, a company developing mobile intelligence and robotic platforms. With a...

16 November, 2024

OpenBOM’s open architecture empowers you to connect seamlessly with a variety of applications and services, enabling efficient collaboration across design...

15 November, 2024

With tariffs on Chinese imports potentially climbing above 60% and increases of 10% or more on goods from other regions,...

14 November, 2024

I’m thrilled to invite you to watch the second Design Projects Live Demo we held yesterday and check out more...

13 November, 2024

Product development success relies on the synergy between multiple team members. It is a teamwork. Engineers, project managers, procurement teams,...

12 November, 2024

I’m excited to share the great story of the Purdue Electric Racing Team and their journey to streamline CAD data...

8 November, 2024

As manufacturing companies are going deep with digital transformation and process optimization, the data integration between engineering and manufacturing has...

To the top