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?