Hi,
The code generates 4 columns, where the calculated one (red) is shown with many digits after the decimal point. How should I use the ROUND function in this case?
Thanks

SELECT City, MedPrice2014, AvgPrice2014, MedPrice2014-AvgPrice2014/MedPrice2014 as PriceGap
FROM [2#1]
where MedPrice2014 <> 0 and  AvgPrice2014<>0
order by PriceGap DESC