on 09-25-2008 12:10 PM
Hi All,
I have three key figures in my report, where third one is addition of first two. All the three key figures are displayed in decimal format 0.0
Now, issue is that if in my report value of two key figures are
KF1 - 0.933333
KF2 - 0.933333
KF3 - 1.866666 (KF1 + KF2)
then it is displayed in report as KF1 - 0.9, KF2 - 0.9 and then KF3 - 1.9, Now the requirement is I want my KF3 is to be displayed as 1.8 not 1.9 (which is rounding of 1.86666)
Please help, as this is bit crucial.
Thanks for the help
Santosh
Hey try if this solves your issue :
Create a new CKF KF4 :
FLOOR(KF3*10) / 10.
Hide KF3 and show KF4 as output
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.