Keyfigure dsiplay problem in BEx Report

[Former Member]

Hello Experts,

In my BEx report i need to display keyfigure values as a whole numbers instead of fraction.I have selected 0 in decimal place of keyfigure properties but the problem is if I have a decimal it gets truncated instead of round figure. Eg. for value 153.65 report shows 153 but I need to display as 154.

Regards

Kumar

[former_member189638]

To be more specific suppose u r having a key fig say KF having the value 153.65.

Don't set any decimal place for the KF. Just go to the properties and hide it

Now create a new formula and set the decimal places to 0 in the properties and use the following formula.

( FRAC ( 'KF' ) < 0.5 ) * FLOOR ( 'KF' ) +

( FRAC ( 'KF') >= 0.5 ) * CEIL ('KF')

Hope this helps

[former_member189638]

Create a formula for the key figure and use the mathematical function<b> FLOOR(Greatest Whole Numbner Value)</b>