Skip to Content
avatar image
Former Member

SAP BO WebI report export to excel : Amount is divided in crores but once exported shown in crores

Dear All,

In WebI report, one column is in crores. When divide this in 1,00,00,000 it is shown in WebI report correctly but exported or save as Excel sheet it returns to original number instead in crores..

Example:

25000000/10000000 = 2.5

113000000/10000000=11.3

1005000000/10000000=105

After exporting to Excel the amount will displaying as

25000000

113000000

1005000000

instead of

2.5

11.3

100.5

We are in SAP BO 4.0 SP6

Kindly do needful.

Thanks,

Raghu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 23, 2017 at 10:19 AM

    Hi,

    did you calculate it or did you user number formatting?

    calculation should work!

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 12:39 PM

    Hello,

    I was not able to replicate the issue, after exporting it shows the same values in Web Intelligence Report. I used the formula on the webi column as

    =[Value]/10000000

    Add comment
    10|10000 characters needed characters exceeded