cancel
Showing results for 
Search instead for 
Did you mean: 

Rounding of sum of key figure issue

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member205352
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Thanks a lot, it solved the issue

Regards,

Santosh

Answers (0)