Skip to Content
avatar image
Former Member

Regarding round-off value in bex query

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Dec 30, 2014 at 10:57 AM

    Hi,

    Try chainging the number of decimal places to 0 .

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 01:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2014 at 04:21 PM

    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. 

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 07:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 31, 2014 at 05:50 AM

    Problem is solved now. Value has been round-off

    Add comment
    10|10000 characters needed characters exceeded