• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8421
  • Last Modified:

How to display percentage on an SSRS Report

I have a row group and for each row I display a count and then display a total for the group in the group footer. I'd like to display the percentage next to the count but I am not sure how to create it. Any help is appreciated.
0
J C
Asked:
J C
  • 5
  • 3
2 Solutions
 
Tony303Commented:
Hi,

Here is a wee example I have made.
You are dealing with rows, which is slightly diffrent but the key I think is to reference your denominator as the Text box value.

You'll get the idea.

T
SSRS.docx
0
 
ValentinoVBI ConsultantCommented:
You can use the Sum() function to calculate the percentage.  This function has several implementations, the one you're after takes two parameters: what to sum and the scope.

Here's what the expression would look like:

=Fields!YourCount.Value / Sum(Fields!YourCount.Value, "YourRowGroup")

Open in new window

This assumes that your count is a field in the dataset.  If it's a calculation in the tablix then you'll want to replace the first parameter in the Sum() call with that calculation.  Note that the Count/CountDistinct/CountRows functions also accept scope.

The expression would become something like:

=ReportItems!YourCountTextbox.Value / Sum(<some Count expr>, "YourRowGroup")

Open in new window

Ow, to format the percentage you can put a P in the Format property of the textbox.  That's just one method, there are several as this article explains: Formatting Numbers [SSRS]
0
 
J CAuthor Commented:
Thank you guys for your help so far, I am having issues and I am sure it's user error but here is what I've got.

Here is my expression

=Count(Fields!question.Value) / Sum(Count(Fields!question.Value), "table1_banswer")

Open in new window


"Warning      1      [rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox21.Paragraphs[0].TextRuns[0]’ contains an error: Input string was not in a correct format.      C:\Users\Liz and Josh\Documents\Visual Studio 2008\Projects\WC Reports\WC Reports\Buyer Profile Summary By Project.rdl      0      0      "

It returns a value of 1 for every row.
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
Tony303Commented:
So did you get it going in the end?
0
 
J CAuthor Commented:
Yeah I was grabbing the sum from the wrong group. I was dividing the count by the sum of the same value. Brain freeze on my part. Once I grabbed the sum of the correct group it all worked as expected. Thanks for your help.
0
 
Tony303Commented:
Cool,

PS. it is customary to give a few points to everyone who helped positively with the question. I know Valentino is the undisputed king of SSRS, and his answer was the best, but a hundred points here and there makes all the difference to mere mortals.

Cheers now, go well, have fun.

T
0
 
J CAuthor Commented:
Tony,

I usually do that but it's been a long week. I'll see if they'll let me redistribute some to you. I appreciate your response and it was leading me in the right direction. Sorry for that.

Thanks
0
 
Tony303Commented:
Don't panic, I'll live. keep smiling.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now