3 Replies Latest reply on Apr 9, 2018 5:03 AM by Avantika Pathak

    Issues with decimal places value

    Avantika Pathak

      Hi,

       

      I am using Tableau Desktop 10.3 version, DB is Microsoft SQL server.

      1. Entity ID is String and it's 4 digits no but when I export it to excel it shows 3 digits.  For Ex - Entity ID is 0921 when I export it becomes 921

      2. Credited Amount and Debited Amount are defined as Number(custom) - i.e. it should consider the amount to 2 decimal places and should include a thousand separators. When choosing crosstab it didn't show decimal places like amount is 314.00 it shows 314. If values is 1245, it shows 1,245.00.

       

      Please find the attached screenshot for details

       

      Regards,

      Avi