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

    Question Unanswered: Want to get results without decimal places

    Hi,

    The underlying table for my fact contains a Sale field whose data type is decimal.

    In the cube editor, I have tried a few options (both for Data Type and Display format) but in my front-end I am still getting the results with 2 decimal places.

    Can someone kindly help me how I can get the results in a rounded form so that the decimal places are not shown e.g. instead of seeing 12,345,678.98 I want the results rounded as 12,345,679.

    If (and i really hope not) it boils down to using MDX in the front end then can u kindly guide me since I can only spell MDX at the moment

    Many thanks in advance for your help.

  2. #2
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    round it when populating fact table

  3. #3
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    with data type currency and display format #,# it works fine

  4. #4
    Join Date
    Oct 2003
    Posts
    163
    Quote Originally Posted by rafala
    with data type currency and display format #,# it works fine
    Tried that but does not work and that's why I posted this request

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Formatting is within the scope of the front-end and should be handles there. What interface are you using?
    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
  •