Hi Experts,
I am having a requirement for rounding values.
In the data basis we have value as "10600000.00". requirement is to apply "input scaling factor" and show without decimal values. which should result in showing value in Bex report as "11".
to Achieve i have created 2 CKF, called 1CKF & 2CKF
1CKF formula "Period Value GC / 1,000,000"
2nd will use the following formula
( FRAC ( ‘1CKF’ ) < 0.5 ) * FLOOR ( ‘1CKF’ ) + ( FRAC ( ‘1CKF’) >= 0.5 ) * CEIL (‘1CKF’)
This is working fine for Positive values like 10600000.00.. showing as 11
However, its not working for the Negative values like -10400000 .. report showing as 11. instead of 10.
Hope i am clear about in detailing my query. Please help.
Thanks
Kamal Kishore Gajula
Add comment