July 13, 2005 at 12:19 am
Hi
I need to concatenate the % sign with a a measure I have(Unemployment Rate)... I wanted to do it thru a calculated member but the samples that i have seen online, need me to provide dimension members and not measures...
is there any way i can do it?if so,plz post a sample expression... if anyone knows a better way to display the % sign with a measure in a chart ,please tell me...i know,creating a calculated member just for this task is wasteful but i had to adopt this way after failing to do so in Reporting Services, reference my post... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=199832
thanx...
replies awaited..
Wajih
July 13, 2005 at 5:18 pm
You could try casting the numeric measure to a string and then appending, e.g.
CStr([Measures].[MyMeasure]) & "%"
Steve.
July 15, 2005 at 1:21 am
Or use formatting in the MDX statement, e.g.
[Measures].[MyMeasure], FORMAT='0.0%'
Helmut
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply