Rounding issue in Formula Keyfigure

[Former Member]

Hi BI Experts,

I have one formula key figure ,this Key figure can have CEIL or FLOOR values as per the client requirement.

For example 9996.01 should appear as 9996 and 78886.99 will also appear as 78887.

Could you please help how to show CEIL and Floor in single Key figure.

Thankyou for your support.

[former_member183519]

Hello sapbibw,

I have faced the same issue. i have also try with formula CEIL and FLOOR, but there is one other way :-

In your KF property tab, make below two seetings:-

1) No of decimal places to ->  0

2) Scaling Factor               -> 1

and after this try to re-run query. it will make round-off .

try this and let me know whether it is working for you ?

Regards,

Hitesh Gavande

[former_member586947]

Hi,

    Say your Keyfigure is KF1. You need to create a formula/CKF as below to get the desired result.

CKF = ( ((FRAC(KF1) < 0.5) * FLOOR (KF1)) + ( ( FRAC(KF1) >=0.5) * CIEL(KF1) ) )

Regards,

Satya.