AnsweredAssumed Answered

Function for Equation in BOM tables

Question asked by Alessio Roman on Jul 28, 2020

Hi there, I'm trying to automatize the order of the components in my BOM.

I'm using several additional columns (then hidden) in order to follow my rules

 

Article Number

Designed components ("Make"):

301 

302

303

30x

 

Commercial componenents ("Buy")
101

102

10x

 

An initial separation is driven by a custom property called "IsCommercialComponent" (which can be "0" o "1") (setted in every single part/assembly of a commercial part/component)
In this way at the bottom of my BOM I have all the commercial components, separated from the "designed components".

 

I've managed to get a full list order till this stage

initial stage (with all the list starting from 301...) 

301

302

303

...

320

321

...

30x

 

to

301

302

303

...

---

122

123

...

12x

 

 

And it's quite fine... 

 

To manage to have a the:

122

123

12x

"resetted" to

101

102

...

10x

 

I need a "minimum" function which looks for a minimum value of a column.

Or at least the minimum value among a selection of vertical cells (of a column) (example K2:K33), like in Excel (well, in Excel this operation is much easier).


I've found this: 

2019 SOLIDWORKS Help - Equations in Tables and BOMs 

 

But I can't use the MIN() fuction... it seems to not recognize nor the a group of cells nor an entire column.

 

Is there any step I missed?
Is there any way to enable this function?
Or any other way to get into a result?

Outcomes