I AM GETTING ERROR LIKE Windowed functions cannot be used in the context of another windowed function or aggregate.

WHEN I AM USING THIS

SUM((PMT/ (sum(SUM(ISNULL(PMT,0)))over() ) * VALUE))OVER()...

there are so many sum function in my select statement,if i do grouping sets ,it will apply to all funcion,i just want for particular function

i have to use that grand total in formula and then i need to show result

coz its joining multiple views and then it comes as a grandtotal

i need to do in sp only

thank you everybody ,i got my solution ,

but just one prob ,coz of to do total i ignore --having SUM(NULLIF(BOOK,0 )) is not null,what is the alternative of using...

nobody understand my prob here,i past my query also, the thing is in my query i need to calculate WAL,

that is only value i need to display ,i cant ...

my question is after i do proportion .again i need to do sum of all proportion and i need to display in row

how to do that

Thank you everybody for your response

YA LIKE THIS,BUT CAN WE USE SUM(SUM(FIELD)) ????

HI

THE THING IS WHAT I WANT IS

ID AMOUNT

1 2000

1 3000

1 5000

2 4500

2 5000

SO...

the things in bold font is the only my prob,i want to do sum(sum(prin)) its not possible in sql

i want alternative of that

hi

here is my script,the font in bold this is what i want to do

SELECT

v.id, ...

i want to do something like this

(sum(isnull(PRIN_PMT))/ sum(sum(prin)) * (datediff(day,'09/30/2010',vc.acct_prd)/365.00) as prin_amount

that i need to place from view into temporary table and there are lots...

if you dont want to help,dont comment