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

  • March 27, 2013 at 10:51 am

    #1601262

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

    --Divya

    This is fine if the value is still a ratio, like .29. If the user already has 29 (multiplied .29 *100) then can do just a

    CSTR(Fields!yourfield.value) + " %" in the cell's expression.

    ----------------------------------------------------