Regarding round-off value in bex query

[Former Member]

Hi Experts,

I have to round-off value like

1012.12  = 1012

1012.525 = 1013

which function should i used?

CEIL and FLOOR are not working.

Please help.

Thanks & Regards

Devesh Varshney

[Former Member]

Problem is solved now. Value has been round-off

[mohd_abdullah]

Hi,

Can you please share the solution ?

Regard.

[Former Member]

same..  number with decimal place = 0   and scaling factor = 1.

It is working fine

[Former Member]

Hello Devesh,

In BEx Properties you can select. NO of decimal place to 0, which will do the job for you.

Or else change the value in Cube itself. and publish it in report.

regards,

AR

[mr_v]

With number of decimal places '0', values should get (1012.525 to 1013) round-off. Issue would be, when you select particular (ex 1013) value from export to excel, the formula bar still shows 1012.525. I tried the combination of number of decimal places '0' and TRUNC. Result is, it tuncates numbers after decimal places, but it does not round-off the value i.e. 1012.525 remains 1012. 

[bhaskar_v3]

Hi Devesh,

If you want to riund off in the BEX then change the scaling factor to 100. So the data will be round with 2 decimal place in the report out.

Regards,

Bhaskar V

[mohd_abdullah]

Hi,

Try chainging the number of decimal places to 0 .

Regards.

[Former Member]

Not working

[former_member194898]

Hi,

It should look like this;

Regards, Leszek

[Former Member]

This is not working

[former_member194898]

In that case ...

Can you tell us something more about construction of KF ? There must be sth non standard with it. What data type is it ?

Regards, Leszek