Hi,

I want to concat the strings a member with %. How do I achieve this.
ex, if ([Measures].[Amount]) = 98 then i want to display it as 98 %.
"Changing the format to Percent is not required in this context".

I tried executing the following query
CStr([Measures].[Amount]) + "%" does not function properly. It dvides
the amount by 100. Similarly, ..+"-" , ... + "+" also donnot function as
expected. However, CStr([Measures].[Amount]) + "XYZ" works fine. It
concats the amount with "XYZ".

Please help me.

Thanks and regards
Subbu
__________________
Thanks and Regards,
SubbuR

--
Posted via http://dbforums.com