Round a Key Figure to the nearest Integer Value

[Former Member]

Hi Expert,

i have the necessity, in BEx, to round a Key Figure to the nearest integer value, for example:

Before:3,4 --> After:3

Before:3,6 --> After:4

The "TRUNC" option simply removes decimals but does not make any approximation.

Many thanks in advance

Fabio

[Former Member · Accepted solution]

Create a calculated KF that use trun(CK + 0,5).

In your sample:

Before:trunc(3,4 + 0,5) --> After:3

Before:trunc(3,6 + 0,5) --> After:4

Hope it helps.

Regards

[Former Member]

Thanks Paolo, that's a good solution!

Message was edited by: Fabio Cappabianca