Find answers, ask questions, and connect with our
community around the world.

Base Camp Base Camp Forums TM1 Technical Rules ROUNDUP in TM1 Rule


  • ROUNDUP in TM1 Rule

    Posted by John on 6-Jan-22 at 9:17 am

    I just discovered this neat method of performing what is essentially the same as a ROUNDUP in Excel. Just add 0.4999999 to your formula and then use the ROUND function.

    This will mean that every value greater than 0.0000001 will be made greater than or equal to 0.5 and then when the ROUND is applied, will equal the next largest integer. Obviously i you need more accuracy, add more 9’s!

    • This discussion was modified 6 months ago by  John.
    • This discussion was modified 6 months ago by  John.
    John replied 6 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.