Skip to Content

Rounding off Issue in Webi Report

Hello All,

We have Issue with Webi , The value in the webi reporting is rounding off, which we don't wanted in our report, and we have used Format number and keeping decimals didn't work as we wanted.

and the Bex query is showing correctly for , example - measure in the Bex showing 45,777.500 , Webi report is rounding off the value 45,778.000.

Does anyone have solution to this, to get rid of the rounding value and keeping the 3 decimals?

current formula we're using is -

=FormatNumber([measure]);"##,#0.000")

Thanks,

Teena

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 12 at 10:37 AM

    Hello Koen,

    the table shows as below - no. of decimals set as 0 - do we need to change this to 3 or something - how we change this table ? is it through global settings?

    Thanks,
    Teena

    Add comment
    10|10000 characters needed characters exceeded