Post reply

How to Round Up the numbers in SSAS

  • May 16, 2007 at 3:50 pm

    #174342

    Hi All

     

    I have this number 143613.992797852

    And i want to round it to 143,614.01

    I get this after i multiply 2 measures in the calculations

    Is there a way to round up in calculations?

     

    Thank you

    Alex S

  • May 16, 2007 at 8:43 pm

    #706981

    interesting approach to rounding...  I could understand 143614.00, or perhaps 143613.993 but i can't quite see how the '2' in the thousandths location enables the 9 to round past 0 up to 1???  Surely that's always going to round downwards?

    Anyways, with both AS2K and AS2K5 you should be able to use the VBA function library (and possibly the Excel library if installed)which should have a Round() function.  Just be aware though, the VBA Round function has it's quirks as outlined here -> http://ewbi.blogs.com/develops/2003/11/vba_round_yet_a.html .

     

    Steve.

  • May 18, 2007 at 11:31 am

    #707549

    Thanks steve.

    Alex S

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply