Need to add % sign for only few rows

Question

Post reply

Need to add % sign for only few rows

vandana_j79

Mr or Mrs. 500

Points: 536
More actions
January 18, 2013 at 5:57 am

#269549

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

Viewing 6 posts - 1 through 5 (of 5 total)

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

Sean Lange SSC Guru Points: 286573 More actions · Answer 1

Please see the first link in my signature about best practices when posting questions.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

abdulkalam.m SSC Enthusiast Points: 168 More actions · Answer 2

use below expression in Avg column

="%" & cstr(Avg.Value)

abdulkalam.m SSC Enthusiast Points: 168 More actions · Answer 3

try below expression

=IIF(instr(Fields!Line.Value, "Avg")," %" & CSTR(MTD.value),MTD.value)

Divya Agrawal Hall of Fame Points: 3144 More actions · Answer 4

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

MMartin1 One Orange Chip Points: 27764 More actions · Answer 5

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.

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