5 Replies Latest reply on Feb 12, 2019 3:44 AM by koushik.neelakantha

    Issue with decimal

    koushik.neelakantha

      Hi everyone,

       

      I am using excel as a datasource and I have sales values as 4,3.9,3.9,4 for respective countries.

       

      Issue i am facing is 3.9 is getting rounded of to 4 automatically when i try to take the sales into worksheet &  values are displaying incorrectly in backend as well(Edit datasource-update data). I need to show as 3.9.I used round function but i am still getting 4,4,4,4 as the output.

       

      I have tried using custom formatting as well, its showing 4.0 but need to show 3.9

       

      Regards,

      Koushik=.