Round decimals to nearest integer

[Former Member]

Hello,

I have a Webi report based on a BEx query and what I need to do is round some decimal numbers to the nearest integer.

For ex.

0.033 -> 1

0. 2    -> 1

0.5     -> 1

I tried with Round() function and FormatNumber() but it's not working.

I'm using BOBJ 4.1 SP5 Patch 2.

Regards,

Ara

[Former Member · Accepted solution]

Use the CEIL function, this rounds up to the nearest integer, as per your example.

NMG