How to display percentage on an SSRS Report

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")

Select allOpen 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.

Maybe specify the values as integers?

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ca281b1d-572d-41be-a612-9d1d943fce9c/how-to-convert-character-value-into-number-value-using-ssrs?forum=sqlreportingservices

So did you get it going in the end?

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.

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

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

Don't panic, I'll live. keep smiling.