I have a column in Excel where values are inserted as decimals, and decimals are presented by the (,) separator. Whenever I am trying to sum the values of the column, I am getting the wrong answer because decimal values are not stored with a (.) separator. I need to know how I can sum the decimal values of multiple rows by using the (,) separator.
Sum = 46.30 expected
SELECT Data.P, Data.co,Data.comp,SUM(Switch(Data.Sens='D',1, Data.Sens='C', -1, TRUE, 1)* Data.Montant) AS Montant FROM data.txt
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)