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.