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.
Author |
Topic |
midpenntech
Posting Yak Master
137 Posts |
Posted - 2008-05-14 : 11:19:56
|
I have a report that i have totaled and working correctly and I am able to get the 2 columns to sum up but I need to get those 2 sumed columns to be divided to get the gross prof %. The columns that I have summed are =Sum(Fields!eqpsldamt.Value)=Sum(Fields!grosspro.Value)I need to take those summed values and divide them but I do not know the propper syntax to do this. I thought it would have been =SUM(Fields!grosspro.Value) / SUM(eqpsldamt.Value)But this did not work any help would be great thanks! |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-14 : 11:23:21
|
Duplicate post:-http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102850 |
|
|
|
|
|