Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Unanswered: How to change display format of my meaure?

    Hi,

    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?

    Looking forward to your help. Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Look, you can write code or a function using conversion and text manipulation functions to display the value however you want, but a general principle of database application design is that data formatting is the job of the interface, not the database server. I strongly suggest that you use your interface or reporting tool to format your results (and Query Analyzer is not a user interface!).
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •