[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8079
  • 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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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