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

[amitrathi239]

Hi,

nearest integer is 0 for 0.33 & 0.2.

If you will use the round function then  for 0.5 you will get 1 and for others 0.

=Round([Number Object];0)

Amit