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

    Issue with decimal


      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