Equation in a BOM table

2D plans Labelling system
1

Hi all

I had made equations in the nomenclature tables in a previous  professional life,

Style: I have 2 types of room: commercial room and off-plan room

the trade part has the properties MARK and REF

the part on plan a: MATERIAL and PLAN

The idea was to limit the number of columns in the nomenclature and to name 2 columns "BRAND / MATERIAL" and "REF / PLAN number"

I had written an equation like this: IF('BRAND'=""; 'MATTER'; "'BRAND')... same with REF and PLAN. I now want to make more formulas that concatenate texts, test results, and part properties.

But nothing works anymore, and the help being quite basic, I haven't found the right syntax even with a few tries, so I'm getting closer to the community with my questions:

- what is the syntax of the sI(condition) function; Si_vrai; Si_faux): should we write IF or IF?

- What are the syntaxes with the apostrophes [ ' ] quotation marks [ " ] and reverse apostrophe [ ' ] (AltGr + 7):  when to use which one?

- How do I concatenate elements? as in EXCEL with the [ & ]  ? or otherwise [ + ] or something else ?

Be careful, there is no formula editor: you  can enter a formula, but before validating, it is better to copy/paste it in a corner, because then IMPOSSIBLE to modify it, you have to retype everything!! GRRR !!

2

Hello

In the help, you have to look for "Test conditions for filling tables". The syntax is well described.

Otherwise as an extract from the same helper: IF('QTE'=1; "Add "'QTY'+2" "'PART NUMBER'" "more"; "Standard")

To be adapted according to the need.

 

3

I found this piece of help that answers many of your questions:

http://help.solidworks.com/2013/French/SolidWorks/sldworks/c_Equations_in_Tables_and_BOMs.htm

And this video:

https://www.youtube.com/watch?v=WVSgamAN0oc

 

2 Likes
4

This is a point that for a long time has sometimes caused me some problems.

Thank you RV69 for asking the question, thank you sba denis for indicating the answer and of course thank you to our Quebec friends.

It works perfectly, all that's missing is the SOMPROD formula