ROUNDUP in TM1 Rule
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!
Sorry, there were no replies found.
Log in to reply.