# Rounding KF

Hi All

Rounding is not working on my query on 3.5Bex.Changed the number of decimals to 0.000 but still working.

Is there any settings need to be changed.

Regards,

Ramana.

##### Rakesh Pattani replied

Don't set any decimal place for the current 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 mathematical functions in the formula.

( FRAC ( 'KF' ) < 0.5 ) * FLOOR ( 'KF' ) + ( FRAC ( 'KF') >= 0.5 ) * CEIL ('KF')

Hope this helps.