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 |
|
SSRSHELP
Starting Member
2 Posts |
 Posted - 2007-11-14 : 12:40:09
|
| I have to get the ratio like A:B with two calculated columns. A and B both are the counts of the rows. Please help me with this, it's really urgent! |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-14 : 12:51:24
|
quote:
Originally posted by SSRSHELP
I have to get the ratio like A:B with two calculated columns. A and B both are the counts of the rows. Please help me with this, it's really urgent!
If it is so urgent! you might want to give a little more information.A ratio would be A/B
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
SSRSHELP
Starting Member
2 Posts |
Posted - 2007-11-14 : 13:06:15
|
| Thanks, here is some more information. For ex. you have to provide the ratio for teacher to the student per class. Counts are done on the Group level.A B Ratio| | Count(A) : Count(B)| | 1:15| |--- ---Count(A) Count(B)3 15 |
|
|
|
|
|
|
Calculate Ratio : Urgent