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 .
In CSV file : 303.56-
In BW: 303,56-
In Analysis: -0,30356
How can I fix it?