Problems in CALCULATING PERCENTAGE in SSRS 2005 Reports..

• Aswanth

  SSChasing Mays

  Points: 608

  More actions

  April 9, 2008 at 1:23 am

  #185123

  I'm Using Asp.Net with C# & Working with SSRS 2005 for Generating Reports..

  The Following Expression I'm using in Reports to Show the Percentage of Particular Items in REPORT..

  =Round((Fields!Clicks.Value*100)/Sum(Fields!Clicks_Show.Value, "DataSet1_Get_All_1234567"),2)& "%"

  With this Expression I'm Getting Reports Percentage(Total) 100%(NO Problem)..

  But for Some Reports it is Coming >100 or < 100 Total Percentage (ie 105% or 95%, --)..

  For Some Reports, I'm Getting SAME PERCENTAGE VALUES to All Items.. (ie In One Report Assume I'm having 4 Items.. I'm Getting ONE Percentage Value to All Items in That REPORT.. Just Like 35%,35%,35%,35%).. But when we Calculate the Items Percentage Values SEPERATELY RESULT is Different (Just Like 35%, 15%, 30%, 20%)..

  I want to Give TOTAL Percentage for ONLY 100% for Reports..

  How to do this..

  What is the Wrong in My Expression.. Why It is Giving Correct Percentage for Few Reports & Wrong Result to Remaining Reports.. & Also Why Same Percentage Values are Repeating for All Items in Few REPORT's...

  Thank You..

• antonio.collins

  SSCrazy Eights

  Points: 9600

  More actions

  April 9, 2008 at 1:32 pm

  #800601

  try simplifying the expression and let RS do the formatting for you.

  =Fields!Clicks.Value/Sum(Fields!Clicks_Show.Value, "DataSet1_Get_All_1234567")

  then set the format to 0.00%