Home Forums SQL Server 2005 Business Intelligence Need to add % sign for only few rows RE: Need to add % sign for only few rows

  • January 22, 2013 at 3:51 am

    #1579520

    vandana_j79 (1/18/2013)

    Hi

    I have SSRS (2008) Report which

    line MTDYTDTotal

    Line 1- Balance 10000200001208987

    Line 1- Volumne 100200330

    Line 1- Avg 426778

    Line 2- Balance 10000200001208987

    Line 2- Volumne 100200330

    Line 2- Avg 426778

    Line 3- Balance 10000200001208987

    Line 3- Balance 100200330

    Line 3- Volumne 426778

    I want to add percentage sign only for Avg. Tried various things but nothing working. Anybody knows how to do this.

    So Avg should be like 42%, 67%, 78%

    All are numeric fields. Spread sheet attached having table

    Many Thanks

    Vandana

    If you are calculating the average value and then showing in the report, just use the FormatPercent function in the expression.

    --Divya