Rounding error on db SUM() #342

New Issue

mpeltriaux · 2023-08-25T08:45:04+02:00

mpeltriaux commented

2023-08-25 08:45:04 +02:00

Status quo

There are rounding errors on SUM() for various float values. These rounding errors are common on float sums and can be easily fixed for our purposes.

Fix

Simply cast the return value of sql's SUM() into a two digit floating point type.

# Status quo There are rounding errors on SUM() for various float values. These rounding errors are common on float sums and can be easily fixed for our purposes. # Fix Simply cast the return value of sql's SUM() into a two digit floating point type.

mpeltriaux added the

bug

label 2023-08-25 08:45:04 +02:00

mpeltriaux self-assigned this 2023-08-25 08:45:04 +02:00

mpeltriaux referenced this issue

2023-08-25 09:41:48 +02:00

# 342 Fix #343

mpeltriaux commented

2023-08-25 14:32:20 +02:00