Sum calculated columns - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Sum calculated columns

Author

Topic

vignesht50
Yak Posting Veteran

82 Posts

Posted - 2014-03-12 : 06:10:58

Hi,

How can I sum the calculated columns.

select [Funding] [Fundings], [Original] [Originals],[Variance] = [Previous_Year]-[Current_Year],[SumValue] = [CurrentYear]/4, [ActualValue] = [Variance] * 0.75,[FinanceYear], [New Value] = [Previous_Year]+[Current_Year] from Finance

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2014-03-12 : 07:01:36

how about?

SELECT fundings,originals,sum(Variance),sum(sumValue),sum(actualValue),sum(newvalue)
FROM (
select [Funding] [Fundings]
,[Original] [Originals]
,[Variance] = [Previous_Year]-[Current_Year]
,[SumValue] = [CurrentYear]/4
,[ActualValue] = [Variance] * 0.75,[FinanceYear]
,[NewValue] = [Previous_Year]+[Current_Year]
from Finance
)A
Group by fundings,originals

Cheers
MIK

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources