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 |
|
matt-_-
Starting Member
1 Post |
 Posted - 2011-01-27 : 12:45:22
|
| I have a got 'gender' field (containing 'male','female','msm') and a 'Total' Field which sums up the numbers by month. However I have got a singular box at the end of the report where I just need to sum up the particular 'gender'so for eaxmple the total sum of female... I cannot just 'sum' up the 'gender' field as this will give me the sum for both 'Male' and 'Female'. I know i may have to put the 'Total field somewhere in my expression as this contains the actualy figuers but have been stuck on this for days, so far i have the following expression...below ...Someone please help!!! :) below is the expression i have thus far including an example of thereport.(is the male and female subtotals i need populating :(=sum(IIf(Fields!Gender.Value = "Female",Diagnosis Gender January Febuary March A male 5 4 B Female 4 3 C male 70 3 D Female 5 2 E male 3 11 Female Total Male Total |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-27 : 13:00:44
|
| =sum(IIf(Fields!Gender.Value = "Female",Fields!yourfield.value,0))------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Sum IF expression help