Page 1 of 1

Round to the nearest 0.5

Posted: Thu Feb 06, 2020 2:12 pm
by rafael.custodio
Hi guys, I need some help to round some values in a report following some rules.

Example:

From 7.1 till 7.4 it should be rounded to 7.5
From 7.6 till 7.9 it should be rounded to 8.0

I know that the Round function follows the international math rounding rules. Is there a way to do this ?
I appreciate any ideas or help with this question.

Re: Round to the nearest 0.5

Posted: Fri Feb 07, 2020 10:34 am
by HighAley
Hello.

Please, try to use this expression:

Code: Select all

{Ceiling(Var*2)/2}
Thank you.

Re: Round to the nearest 0.5

Posted: Fri Feb 07, 2020 12:37 pm
by rafael.custodio
@HighAley, it worked. Thanks a lot !!

Re: Round to the nearest 0.5

Posted: Fri Feb 07, 2020 12:40 pm
by HighAley
Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.