3 Replies Latest reply: Oct 7, 2014 8:55 AM by Peter Raijmakers RSS

    Join on rounded value not working

    Peter Raijmakers

      Hello,

       

      I have a problem of which i think it is a bug.

      Our database has values like this: 56,99999999994 or 23,99999999997

       

      Now i need to join data based upon the rounded value (57 or 24) of this field.

      This does not work for two cases:

       

      if the number is xx0,9999999999 -> rounded to xx1

      or if the number is xx5,9999999999 -> rounded to xx6

       

      For this the join does not match and therefore joined fields are empty.

      for all other rounded values the join does match. is this a bug or am i overlooking something??

       

      your help would be much appreciated.