SELECT SalesUSD,SalesUSDYear,100 * (o.SalesUSD - o.SalesUSDYear) / o.SalesUSDYear FROM
(
SELECT CAST(Yestoday AS MONEY) + CAST(TwoDaysAgo AS MONEY) + CAST(ThreeDaysAgo AS MONEY)
+ CAST(FourDaysAgo AS MONEY) + CAST(FiveDaysAgo AS MONEY) + CAST(SixDaysAgo AS MONEY) + CAST(SevenDaysAgo AS MONEY) AS SalesUSD,
CAST(YearOnYear AS MONEY) AS SalesUSDYear FROM dbo.RB_Report_StatisticsBoard WITH(NOLOCK)
WHERE CustomerID = 1 AND Name = '销售额'
) o