AnsweredAssumed Answered

Fomulas in BOMs

Question asked by Dan Miel on Sep 22, 2008
Latest reply on Sep 23, 2008 by Dale Dunn

Like • Show 0 Likes0
Comment • 3

I created a part and made a custom property called BulkQty as text and entered 3 OZ as the value and inserted the part into an assembly file. I then created a drawing with the assembly and inserted a BOM with a column for the BulkQty. I tried to write a formula in another column " =(`BulkQty`)" but it doesn't seem to read the BulkQty column. I then put the row/column address of E9 but it only reads the number 3 but not the text "OZ." I would eventually like to have it read the value of BulkQty is if it is greater than zero otherwise use the value of the QTY. column. From what I have read I thought something like " =If(#`BulkQty` > 0 ; 'QTY.";`BulkQty`)" would work but I am nowhere close to working this one out. Can anyone help?

Thanks

Dan Miel
2008

Dan Miel Sep 23, 2008 1:27 PM

Correct Answer

Dale
I was putting the equation in a single cell. When I put your equation in a single cell it did not work but when I entered your equation in for the whole column it seems to be working. I think at some point I had tried the same equation before but entering it as a column equation instead of a cell equation may have been the trick.
Thanks Dale

Dan

See the reply in context

No one else had this question

Outcomes

Dale Dunn Sep 23, 2008 12:45 PM

Try a structure like this:

IF('BulkQty' <>"";'Bulkqty';'QTY')

My syntax is probably messed up, since I don't do this often enough to have it memorized. That's why I always select column names and custom props form the lists. The point is, this will use BulkQty if 'BulkQty' is not nothing.

Actions

Dan Miel @ Dale Dunn on Sep 23, 2008 1:27 PM

Actions

Dale Dunn @ Dan Miel on Sep 23, 2008 1:32 PM

Hahaha. I had forgotten you could use equations in individual cells! I've never had a need for that. So, I sort of assumed you were using the equation on the whole column.

Glad I at least triggered finding the solution.

Actions

3 Replies

Dale Dunn Sep 23, 2008 12:45 PM
Mark Correct
Correct Answer
Try a structure like this:

IF('BulkQty' <>"";'Bulkqty';'QTY')

My syntax is probably messed up, since I don't do this often enough to have it memorized. That's why I always select column names and custom props form the lists. The point is, this will use BulkQty if 'BulkQty' is not nothing.
Like • Show 0 Likes0
Actions
- Dan Miel @ Dale Dunn on Sep 23, 2008 1:27 PM
  Unmark Correct
  Correct Answer
  Dale
  I was putting the equation in a single cell. When I put your equation in a single cell it did not work but when I entered your equation in for the whole column it seems to be working. I think at some point I had tried the same equation before but entering it as a column equation instead of a cell equation may have been the trick.
  Thanks Dale
  
  Dan
  Like • Show 0 Likes0
  Actions
  - Dale Dunn @ Dan Miel on Sep 23, 2008 1:32 PM
    Mark Correct
    Correct Answer
    Hahaha. I had forgotten you could use equations in individual cells! I've never had a need for that. So, I sort of assumed you were using the equation on the whole column.
    
    Glad I at least triggered finding the solution.
    Like • Show 0 Likes0
    Actions

Fomulas in BOMs

Outcomes

Related Content

Recommended Content