4 Replies Latest reply on May 1, 2013 2:58 PM by Alex Kerin

    Simple calculations getting incorrect results

    Son Stegmaier

      I was validating some results from Tableau to excel and noticed that the calculation incorrect.

       

      calc.PNG

       

      The above image shows the table layout with calculations.  I am trying to calculate Register / Total. 

      Taking Less than $20,000 as an example:  .055223 / .021127 = 2.61385904 (Tableau results show 2.6139137)

      The same incorrect results are computed when I take Activator / Total or Redeemer / Total

       

      Activator

      .018306 / .021127 = .866474

      Tableau's results ~  .866464

       

       

      Redeemer

      .014681 / .021127 = .694892

      Tableau's results ~ .694915

       

      I attached a sample workbook.