Question about using format in MDX - for MDX experts

Hi,

First, I know I have my basics wrong here so let me first give a
background. Please ignore this stupid part

1,000,000 = 100 Thousand. Right?
10,000,000 = 1 Million. Right?
100,000,000 = 1 Billion. Right?

Please help me clear up my understanding if the above is wrong and again
I know this is a very silly question. I know that the question below
could have been phrased much clearer if my basic concept about the #'s
was correct so please bear with me and guide me where you can...


Now

I want to use the format function in MDX in such a manner that if the
maximum sales is 10 Thousand then the measure total should be shown in
Thousands e.g. 0.5 T, 1.2 T, 3 T, and so on

if the maximum sales is 1 Million then the measure total should be shown
in Millions e.g. 0.12 M, 0,5 M, 4 M and so on


Many thanks in advance for your help.

 

Are you really sure you want this ?

Sounds like you need different reports...one formatted in thousands, one in
millions and so forth...

If you make a sentence which automatically formats the numbers you would'nt
know what youre looking at...would you ?

About formatting the numbers you can use the #'s ... don't know which front
end youre' using but in xp these can be used as well.

And these codes can be used in Analysis Services. Examples:

Thousand #,#00,
Million #,##0,,
etc...

I'm not sure if you need to change these if you have a different language -
dont think so.

\Michael Vardinghus

 

Thanks for the reply.

Two last questions please: If I use the "#,#00," for Thousands, can I
use "#,#00, T" to indicate that the values are in thousands?


Also how do I solve the part where I apply the formatting as per my
question I.e.

Suppose my MDX currently is as follows:
iif(Current dimension.name=Open Time dimension.name,null,((Length
measure,Open Time dimension.currentmember)-(Length
measure,parallelperiod(year,1,Open Time dimension.currentmember)))
/(Length measure,parallelperiod(year,1,Open Time
dimension.currentmember))*100)


Sorry for the botheration.

Regards.