4 Replies Latest reply on Jun 14, 2018 4:02 AM by Sankarmagesh Rajan

    Live vs. Extract gives different values

    Anna Borovcova

      Hi,

       

      I am quite new to Tableau so pardon me if I am not 100% correct in expressions.

      I have a huge problem now. When I am using packaged workbook  with extract and I do sales sum calculation I get value: 1 238 855 243.

      However if I perform SQL query on the same data I get: 1 128 318 776.

      When I try to do the live version in separate tableau workbook it matches the SQL query.

      Is there any reason for such difference? I have not changed anything in the database. We are using Microsoft SQL Server.

      Thanks for any advice!

       

      Anna