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

[Former Member]

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

[former_member316829]

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

[kohesco]

Hi,

did you calculate it or did you user number formatting?

calculation should work!

Grtz

Koen