AnsweredAssumed Answered

Need HELP w/Equations in BOM

Question asked by Jake Everett on Sep 20, 2012
Latest reply on Sep 21, 2012 by Daen Hendrickson

It has been almost 4 years now since I first asked this question. I'm hoping there may be someone with an answer by now...

 

I have a SW BOM in which I have three columns that display X_DS, Y_DS & Z_DS (x, y & z values of a part)

I want to combine the three columns into one column called "FINISHED SIZE" that would display a callout something like this:   .375 x 2.250 x 4.000 (smallest no. first & largest no. last)    Here's the kicker, X_DS=2.250, Y_DS=4.000 & Z_DS=.375   BUT sometimes the values may be different, ie.  X_DS=.375, Y_DS=4.000 & Z_DS=2.250.......  I always want the value in the "FINISHED SIZE" column to display as  (small # x  medium # x large #)

Any help is appreciated

Outcomes