March 22, 2015 at 1:12 pm
Hi
I have a problem with a table in a ssrs report.
I have grouped one row with gender values. And I have a Total value below gender. The rows holds number of female and numbers of males and their total salaries. I count female and male with countRows().
How do I calculate the number of female and male in % of total regards to number and their salarys with an expression.
I want something that looks like this in my brain:If Female:
((countRows if gender="female")/(countRows for total))*100
((sum(Fields!salary.value) if female)/(sum(Fields!salary.value) for total))* 100.
And the same thing for Male. The problem here I think is that I have grouped my row with gender but if I don´t do that I need som way to condition my row values. Can someone please help me with this expression. I wish there where some if, where condition. I have read and understand that IIF maybe can be useful in some way here nut I don´t kno how.
March 22, 2015 at 2:14 pm
I have done something like this before by creating a variable and populating it with the count of "people". Then you divide by that.
March 23, 2015 at 10:07 am
Thanks! It worked with a variable that holds the total value of the whole set.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply