When i multiply one column with another in a BOM, anything with a negative number equals to zero.
If I manually multiply the cells I get the correct answer (-0.6).
When i multiply one column with another in a BOM, anything with a negative number equals to zero.
If I manually multiply the cells I get the correct answer (-0.6).
Hello,
SW may be doing the math, but it could be the number of displayed decimals is defaulting to none.
In your equation, place the cursor at the beginning of the line and select, from the "Precision" dropdown, "1" or "2" places.
The number will be between curly braces and must be before the formula.
See if that fixes things (even though -0.6 at zero decimal places is -1, not zero).
Cheers,
Kevin
Hi,
Thanks for the suggestion, but I still get the same result:
Cheers,
Christian
Hello,
I put some conditional equations to test what SW considers the <0 values.
The 'rr' column is -1*QTY (I didn't have anything negative readily available).
The unlabeled column two over to the right of 'rr' is 'rr' * 'QTY.', computing to zero.
The unlabeled column to the right of 'rr' is the conditional test column, returning either 'rr' or 'QTY.' if 'rr' '=0' or if it '<>0'.
'QTY.' is returned when 'rr'=0, so SW is considering numbers less than 0 as exactly zero, which explains why the multiplication equates to zero.
To get around this, it looks like you'll have to go cell-by-cell with the formula.
I'd report this to SW as a failure (if it already hasn't been) in need of correction.
Cheers,
Kevin
Is there any way to fix this without manually multiplying the individual cells?