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
Bookmarks