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 |
|
florence
Starting Member
2 Posts |
 Posted - 2010-09-21 : 09:00:12
|
| I have the scenario below to calculate percentage.(A) 100 33.33% 300 42%(B) 200 66.66% 400 58%(A+B) 300 700The 1st column has (A),(B),(A+B)The second column has the values 100,300,200.400 and so on.I need to calculate the 3rd column i.e. the percentages.The 1st row of (A) is divided by the 1st row of(A+B),The 2nd row of (A) is divided by the 2nd row of(A+B) and so onCan anyone help how this can be done. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-21 : 12:28:58
|
| are you asking for report expression?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
florence
Starting Member
2 Posts |
Posted - 2010-09-21 : 14:34:14
|
| Yes, expressions that will be needed in the percentage textboxes |
|
|
|
|
|
|
problem calculating percentage in ssrs