Alright if there's any code wizards out there I've got one for you. For our BOMs we show a length column, which for most items doesn't apply to most electrical components except for din rail and wiring duct. Does anyone know a way to return a blank value or empty cell if the BOM length is zero?
We show the length in inches and the default formula was STR (bom_length / 25.4, 10, 2). Not sure what exactly the 10, 2 is for at the end but that is how SWE had this set up to show length in inches and it works (also works without the 10, 2 at the end).
I tried a simple IIF statement: IIF(bom_length > 0, STR(bom_length / 25.4, 10, 2), ""). To no avail, the zeros are still there. Even if I put text in between the quotations I still get a zero back on the BOM. I'm not a coder and I'm hoping someone will be able to answer this one pretty easily.