AnsweredAssumed Answered

Nested IF statements in a BOM

Question asked by Tom Cote on Mar 8, 2012
Latest reply on Jan 23, 2018 by Thijs Vernooij

I'd like to create a create nested If-Then statements inside a BOM but cannot get through the first one.  Basically what I would like is that if Largeur and Longueur are both equal to SO then I want the cell to be blank.  I know how to do this type of equation in Excel but cannot get it to work inside OF SW BOM's.  I have tried this in several different "tweaks" to the equation but no luck

 

IF(`Largeur`= "SO"; `Largeur`; ""; IF(`Longueur`="SO";`Longueur`; ""))

 

Any help would be greatly appreciated.

Thanks

Tom

Outcomes