A place for Apptio product users to learn, connect, share and grow together.
How do I round 1.3 to 2?
Round() isn't an option.
@Matthew Poletiek where are you looking to apply this? Table? Report?
Either way should work.
Likely a cleaner solution exists, but this works:
=If(Split(Amount,2,".")="", Amount, Trunc(Amount+1))
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?
Give the formula a try, it should round up any number which contains a decimal value.
Ahh I see it now. Thanks Chris!
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.
Done!
Awesome, thank you @Matthew Poletiek!