Skip to Content
0
Dec 16, 2019 at 08:10 AM

Analysis for excel: wrong decimal separator

340 Views

Good day, everyone!

I have a problem with values in Analysis for Excel. They are different then in BW.

Data flow looks like this:

1) Source system: CSV file. Value: 2490.00-

2) Upload csv file data into BW.

3) Store data in DSO. Value: 2.490,00- .

4) Create Bex query

5) Run query from Analysis for excel. Receive value: -2,4900

It seems that Analysis thinks that thousands delimiter in BW is a decimal decimeter .

Another example:

In CSV file : 303.56-

In BW: 303,56-

In Analysis: -0,30356

How can I fix it?

Regards,

Miloslav