2 Replies Latest reply on Jan 19, 2019 3:55 PM by Dmitry Chirkov

    INT function doesn't show right data

    kookhee kim

      Hello!!

       

      I tried to show integer number by using INT() function.

      Most of data shows right data, but some data shows wrong number which subtract 1 from real number.

      I tried to figure out this matter by watching decimal number but I couldn't find the reason.

       

      Could you please help me how to show right number???

       

       

      "INT MSRP" is the data I used INT() for Extended MSRP Sales Amt (the right one)

      As you can see, INT() shows 49,999 when I use it for 50000.