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 |
|
liorlankri
Starting Member
17 Posts |
 Posted - 2006-01-24 : 03:59:08
|
| I have a column group. How can I get to the SubTotal value of this group. I want to divise value x with this Subtotal value.How can I access this value? |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-24 : 08:11:25
|
| can u put Table / columns & some sample data and how do u like to c it.Also in what reporting tool u want to c this? |
 |
|
|
mallykarjuna
Starting Member
5 Posts |
Posted - 2006-01-25 : 08:18:08
|
| U can calculate the subtotal using "scope" as SUM(<field>.value, "<group name>"). <group name> is the NAME of the group and not the grouping. Hope this helps u.<group name> should be in double quotes("). |
|
|
|
|
|
|
How to get Subtotal value?