How to get the percentage presentation of a returned value in MDX?

Hi, All,

How can we get the percentage presentation of a value (e.g. a/b, I want to get the result presented in percentage format). How can we achieve this in MDX?

Thanks a lot and I am looking forward to hearing from you shortly.

With best regardsd,

Yours sincerely,

Hi, experts,

Please help me out!

Thanks.

With kind regards,

Yours sincerely,

|||

Hi Helen

You need to create a calculated measure and then use Format_STRING:

Code Snippet

WITH

MEMBER [Measures].[yourMeasure] as

([Measures].[A] / [Measures].[B]),

Format_string="0.000%"

SELECT

[Measures].[yourMeasure]

ON COLUMNS

FROM

[Your Cube]

Hope this helps

Tim

|||

Hi, Tim,

Thanks a lot for your suggestion.

It works perfect.

With kindest regards,

Yours sincerely,