Skip to Content
0
May 31, 2013 at 07:35 AM

Round off Te Key Figure in SAP BeX

392 Views

Hello Experts,

I have one formula KF which is showing No of Boxes. After executing the query, decimal values are coming(as per calculations) in No of boxes. E.g. 0.23, 0.63, 1.25 etc.

My requirement is to show as :

No of Boxes Round-Off No of Boxes

0.23 1

0.63 1

1.25 2

The 'Round-oFF No of Boxes' should always show the high value.

How can i round-off the values in query designer as per the above requirement.

Thanks,

Abhimanyu Sharma