Skip to Content
0

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

Feb 23, 2017 at 10:06 AM

69

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Feb 23, 2017 at 10:19 AM
0

Hi,

did you calculate it or did you user number formatting?

calculation should work!

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded
Deepak Aswale Feb 24, 2017 at 12:39 PM
0

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


webvalues.png (46.4 kB)
Share
10 |10000 characters needed characters left characters exceeded