7 Replies Latest reply on Oct 7, 2014 2:21 PM by David Suelflow

Equation Not Returning Correct Answer

David Suelflow Oct 7, 2014 10:15 AM

I have an equation (“RD#@Annotations”*.104) that does not return the correct answer. By my calculations if “RD#@Annotations” is 561 than the result should be 58.344 (at least according to my calculator and Excel). The equation editor in SW says it is 56.09375. Has anyone run into a situation where they get the wrong answer to an equation?

Re: Equation Not Returning Correct Answer

Jeff Mirisola Oct 7, 2014 10:35 AM (in response to David Suelflow)

Not knowingly...
That's an odd error for sure. If you manually input the info, does it work? What if you change the multiplier? Have you deleted the formula and retried it?
Like Show 0 Likes(0)

Actions
- Re: Equation Not Returning Correct Answer
  
  David Suelflow Oct 7, 2014 10:40 AM (in response to Jeff Mirisola)
  
  No, it seems that SW rounds the .104 to .1, if I change it to .106 it rounds it to .11. It looks like it is using a "Bankers Round" where it only goes to 2 places.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Equation Not Returning Correct Answer
    
    Ian Worrall Oct 7, 2014 10:45 AM (in response to David Suelflow)
    
    Check Tools / Options / Document Properties / Units.
    Dimension decimal places are set there, SW may be using those to round?
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Equation Not Returning Correct Answer
      
      David Suelflow Oct 7, 2014 11:16 AM (in response to Ian Worrall)
      
      Units are set to .12345... if I start a new part it works ok so there must be something in the document properties that is controlling.
      
      Like Show 0 Likes(0)
      
      Actions
Re: Equation Not Returning Correct Answer

David Suelflow Oct 7, 2014 12:40 PM (in response to David Suelflow)

Ok… After a bit of poking around it turns out that in SW 2014 if your units are set to feet-inches, the equations have a bankers round (.104 becomes .10 and .106 becomes .11). If you set your units to inches, the equations/variables evaluate normally. This is no so in 2012. This may not be a big deal for some but when I have a product that is 45 feet long it puts me off by a few inches. Now if I could only figure out how to get SW to unlock my customer portal I will submit an SR…
Like Show 0 Likes(0)

Actions
- Re: Equation Not Returning Correct Answer
  
  Arthur Loginow Oct 7, 2014 12:54 PM (in response to David Suelflow)
  
  David can you please check the (...) button at the right and see if the "Round to nearest" option is checked, if it is then disable it and try again please
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Equation Not Returning Correct Answer
    
    David Suelflow Oct 7, 2014 2:21 PM (in response to Arthur Loginow)
    
    Nope... we tried all of those options. The only thing that seems to have an effect is the Feet & Inches setting. I've submitted a Service Request to see if they can fix this.
    
    Like Show 0 Likes(0)
    
    Actions

Go to original post