Always ROUND UP to the next full GB?

[ReCal]

Hi.
How can I always round up from 0.01GB to the next full 1GB?
SELECT node_name, CAST(FLOAT(SUM(reporting_mb)) / 1024 AS DEC(8,2)) FROM occupancy GROUP BY node_name
THX
Regards
Rene

 

[ReCal]

SELECT node_name, CEILING((SUM(reporting_mb)) / 1024) AS "GiB" from occupancy group BY node_name