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.
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.