Hi,
Create two CKFs - Budget and Actual and set the Properties of the key figures in BEx. Go to Calculations > Local Calculations > Calculate Results As... > Summation of Rounded Value.
Use these CKFs in further calculations. Hope this would resolve your issue.
Regards,
Geeta
Hi,
Please try out these formulas:
If you want to round a key figure "KF" to have zero decimals: ( FRAC ( 'KF' ) < 0.5 ) * FLOOR ( 'KF' ) + ( FRAC ( 'KF') >= 0.5 ) * CEIL ('KF') An equivalent MS Excel formula you can use to test is: =IF(A3-TRUNC(A3)<0.5,FLOOR(A3,1),CEILING(A3,1)) If you want to round a key figure "KF" to have 2 decimals: ( FRAC ( 'KF'*100 ) < 0.5 ) * FLOOR ( 'KF' * 100 ) / 100 + ( FRAC ( 'KF' * 100 ) >= 0.5 ) * CEIL ('KF' * 100) / 100 The equivalent MS Excel formula to test it is: =IF(A5*100-TRUNC(A5*100)<0.5,FLOOR(A5*100,1)/100,CEILING(A5*100,1)/100 )
Hope it helps.
Regards,
AL
Try this link and look for the sample for floor, ceil and frac. by this, you will easily understand the process that takes place on each operator and you will easily formulate different logic by using those three in different situations on decimal places.
Hi,
there two options
1. carry out KF rounding . But in your case calculation is there,it will not correctly there
2. You only need to go either for ABAP code or use formula as suggested in other posts.
Thanks and regards
Add comment