Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.



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

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question