Re: Question about using format in MDX - for MDX experts

#1

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.

Quote:

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

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Question about using format in MDX - for MDX experts

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Question about using format in MDX - for MDX experts - 04-11-2004 , 10:05 PM