Post reply

Working with DIVISIONS in Reports in SSRS-2005

  • 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

  • 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..

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply