Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 How to change display format of my meaure?

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2004-04-09 : 08:13:23
Is it possile to definea custom format for the 'display format' property of a measure so that the results are shown in Thousands or Millions or Billions e.g

100,000 can be shown either as 100T
OR
1,000,000 can beshown as 10M
OR
10,000,000 1B


Sorry if I got my numbers wrong but I hope you get the idea?

Thanks & Regards.

-J
   

- Advertisement -