Shopping Cart

No products in the cart.

Shopping Cart

No products in the cart.

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

TM1 Explorers: Explore, Challenge and Summit with TM1 › Base Camp Forums › TM1 Technical › Rules › ROUNDUP in TM1 Rule

Tagged: 

  • Rules

    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 1 year, 2 months ago by  John.
    • This discussion was modified 1 year, 2 months ago by  John.
    John replied 1 year, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Start of Discussion
0 of 0 replies June 2018
Now

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .