on 06-04-2010 1:15 PM
Hi,
i raised before one issue regarding decimal places . Actulay my requirement is if CKFA = CKF B is equal to count 1 . So user asked to keep 2decimal places after the point .then only system has calculating count 1 .If i not set 2 decimal place system is not showing count 1 . i tried KF properties set to 2 decimal place in backend but its not showing 2 decimal places.is ther any bex functionality is ther approximately equal so with out changing any thing my issue has been solved.
CKF A CKF B
1.251851852 1.251922141
Regards
RK
So I would try to solve this one of two ways.
1) In the properties for the calculated key figure that stores the results of the CKF A = CKF B test, I would go to calculation tab, in Calculate Results As... select Summation of Rounded Values.
If that doesn't work...
2) Create one CKF (CKF C) which tests the results of the CKF A = CKF B logic. Give it 1 if the result is true, 0 if false. Then create a second CKF (CKF D) which is the average of CKF A and CKF 2 and change the decimal places for this. Then a third CKF (CKF E) which is the product of CKF C and CKF D (i.e. CKF C * CKF D).
Let me know how it goes...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.