3 Replies Latest reply: Feb 7, 2018 10:20 AM by Mikel De RSS

    Calculation error

    Mikel De

      Hello!

       

      I am calculating the price per item by diving Value by Quantity. I decided to do this in the script and created a calculated column Price using the same expression. As you can see in the table below, the result is the same, but strangely enough, if I subtract  the new price from the old price, the result is not always 0.

       

      Capture.PNG

       

      This happens for only 2 out of 60 months in the analysis. What could be the reason?