- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2023 11:20 PM
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023 12:50 AM
I think it is half_up (so starting from 5 round upwards).
with the round() and bround() function you can control the rounding.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023 12:50 AM
I think it is half_up (so starting from 5 round upwards).
with the round() and bround() function you can control the rounding.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2023 11:10 PM
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

