thats exactly what I needed, thanks!

Ok, so here's a simplified version of what I want to do. After running the Report Script, I want only the 'Total_Costs' for all 'Report Total' to be rounded.

I've...

Ok, I am still pretty new to SQL.

So is the CASE statement you're talking about something like this (building on the example earlier)

SELECT

CASE WHEN (Grouping(Store)=1) THEN 'Report Total'...