Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only
  • 1.  ROUNDUP ?

    Posted 07/26/18 03:58 PM

    How do I round 1.3 to 2?

    Round() isn't an option. 




    #TBMStudio


  • 2.  Re: ROUNDUP ?

    Posted 07/27/18 02:32 AM

    @Matthew Poletiek where are you looking to apply this? Table? Report?


    #TBMStudio


  • 3.  Re: ROUNDUP ?

    Posted 07/27/18 11:07 AM

    Either way should work. 


    #TBMStudio


  • 4.  Re: ROUNDUP ?
    Best Answer

    Posted 07/27/18 02:47 PM

    Likely a cleaner solution exists, but this works:

    =If(Split(Amount,2,".")="", Amount, Trunc(Amount+1))


    #TBMStudio


  • 5.  Re: ROUNDUP ?

    Posted 07/30/18 11:47 AM

    What if 1.3 isn't always 1.3?

    What if I wanted to round all numbers with a decimal to the next whole number? 


    #TBMStudio


  • 6.  Re: ROUNDUP ?

    Posted 07/30/18 11:50 AM

    Give the formula a try, it should round up any number which contains a decimal value.


    #TBMStudio


  • 7.  Re: ROUNDUP ?

    Posted 07/30/18 05:30 PM

    Ahh I see it now. Thanks Chris!


    #TBMStudio


  • 8.  Re: ROUNDUP ?

    Posted 07/31/18 12:15 PM

    Hey @Matthew Poletiek, if your question has been answered be sure to mark the comment with the correct answer as correct so that if others have the same question they can find the answer here.

     


    #TBMStudio


  • 9.  Re: ROUNDUP ?

    Posted 07/31/18 03:52 PM

    Done!


    #TBMStudio


  • 10.  Re: ROUNDUP ?

    Posted 07/31/18 03:55 PM

    Awesome, thank you @Matthew Poletiek!


    #TBMStudio