Skip to Content
avatar image
Former Member

BO4.2 - WEBI Number format

Nov 25, 2017 at 01:31 PM | 110 Views

Hi All,

I am trying the below number format in Webi.

Eg: Original value = 230562.05

Webi has to display = 231

After export to excel it has to display in front end view has 231 and after click that specific cell it has to show original figure 230562.05

Note: Directly in excel I tried using this format #,##0, and working fine, but not in WEBI

Kindly advise on the same.

Regards,

R. Saravanan

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    AMIT KUMAR
    Nov 25, 2017 at 01:46 PM

    right click on the column-format number and define the custom format to #,##0 and try

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2017 at 04:23 PM

    Hi,

    I have done the same but no result.

    Regards,

    R. Saravanan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 26, 2017 at 05:33 AM

    Hi,

    Anyone done this requirement? Kindly help on this.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    AMIT KUMAR
    Nov 27, 2017 at 09:34 AM

    Instead of using custom format use predefined format.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2017 at 03:08 PM

    Hi Amit,

    Thanks for your reply.

    I have already tried and below result not getting.

    Eg: Original value = 230562.05

    Webi has to display = 231

    Regards,

    R. Saravanan

    Add comment
    10|10000 characters needed characters exceeded