Working with DIVISIONS in Reports in SSRS-2005

• brunm

  SSCommitted

  Points: 1792

  More actions

  March 6, 2008 at 8:26 am

  #786028

  I don't know if this answers your question but

  In the situations where i know that the result will always be 100% then i have cheated by putting in theText of 100%

  i had to do this as i was adding up fractions with massive amounts of decimal points and when i rounded them and totalled them i could never get 100 %

  i suppose it depends on exactly how accurate your data must be

• Aswanth

  Mr or Mrs. 500

  Points: 548

  More actions

  March 6, 2008 at 10:51 am

  #184848

  I'm Using the following Expression for Division in SSRS-2005 in C# Web Applications..

  =Round(((Fields!Price.Value*100)/Sum(Fields!CPU.Value, "DataSet1_AmountDetails")),2) & "%"

  When I'm Using this Expression i'm getting the Result as i'm expecting ..

  ie.. 10.25%, 15.45%, 12.14%,.....

  But the Problem is When i'm adding all the Values it is giving me 102.56%..

  But I want to Show the Chart for only 100%..

  If i'm not adding this Decimal points i'm getting the Total of 99%.. (ie 10,15,12,.......)

  What can I do Now for getting the Chart to Show the Result of 100%..

  Please give me any Suggestions..

  Thank You..