Round to the nearest 0.5

[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.

[HighAley]

Hello.

Please, try to use this expression:

Code: Select all

{Ceiling(Var*2)/2}

Thank you.

[rafael.custodio]

@HighAley, it worked. Thanks a lot !!

[HighAley]

Hello.

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

Thank you.