By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1 (
`id` INTEGER,
`desc` VARCHAR(7),
`amount` FLOAT64
);
✓
INSERT INTO table1
(`id`, `desc`, `amount`)
VALUES
('12345', 'Item 1', '-228568.9'),
('12345', 'Item 2', '-61734.3'),
('12345', 'Item 3', '-532978.4'),
('12345', 'Item 4', '-3193.7'),
('12345', 'Item 5', '-4258.25'),
('12345', 'Item 6', '92189.85'),
('12345', 'Item 7', '-1602.3'),
('12345', 'Item 8', '-48746.25'),
('12345', 'Item 9', '-61734.3'),
('12345', 'Item 10', '-11710.25'),
('12345', 'Item 11', '-0.05'),
('12345', 'Item 12', '-0.05'),
('12345', 'Item 13', '-0.05'),
('12345', 'Item 14', '-228568.9'),
('12345', 'Item 15', '-15968.6'),
('12345', 'Item 16', '-12774.85'),
('12345', 'Item 17', '-32306.75'),
('12345', 'Item 18', '-48746.25'),
('12345', 'Item 19', '213330.95'),
('12345', 'Item 20', '0'),
('12345', 'Item 21', '-15968.6'),
('12345', 'Item 22', '-0.05'),
('12345', 'Item 23', '45496.5'),
('12345', 'Item 24', '57618.65'),
('12345', 'Item 25', '497446.5'),
('12345', 'Item 26', '-0.05'),
('12345', 'Item 27', '-0.05'),
('12345', 'Item 28', '387874.5'),
('12345', 'Item 29', '14904'),
('12345', 'Item 30', '-0.05');
✓
SELECT id,
SUM(CAST((100 * amount) AS INTEGER)) / 100.0 AS [TOTAL PAID]
FROM table1
GROUP BY ID;
| id | TOTAL PAID |
|---|---|
| 12345 | 0 |
SELECT id,
ROUND(SUM(amount), 2) AS [TOTAL PAID]
FROM table1
GROUP BY ID;
| id | TOTAL PAID |
|---|---|
| 12345 | 0 |