topic Decimal Automatic Rounding on sum in Data Engineering

Decimal Automatic Rounding on sum

PragyaS — Fri, 09 Jun 2023 06:20:45 GMT

I am facing an issue, I have implemented a code in which I am performing sum on decimal values. I have set precision as Decimal(19,2). When I am calculating for big data I am getting different value as I got from my .Net Utility application. ex. From .Net Utility O/P : 19546.45 and in databricks : 19546.46. I am not sure why databricks is changing values automatically? I need to make sync between .Net utility & databricks data. What is default rounding in decimal precision while doing sum in databricks? Can someone help me for this?

Re: Decimal Automatic Rounding on sum

-werners- — Fri, 09 Jun 2023 07:50:50 GMT

I think it is half_up (so starting from 5 round upwards).

with the round() and bround() function you can control the rounding.

Re: Decimal Automatic Rounding on sum

Anonymous — Wed, 14 Jun 2023 06:10:05 GMT

Hi @Pragya Sharma

We haven't heard from you since the last response from @Werner Stinckens . Kindly share the information with us, and in return, we will provide you with the necessary solution.

Thanks and Regards