Hello guys. I have a tracking table in Google Sheets. Whenever a customer buys something, I want the cell to be updated. So that I can always see the total value of all payments. If I do a sum for example with 500.00 and 300.00, it works = Result 800.00 Great!
After the thousand mark, however, the problems start. The value in the Google Sheet Cell is 1,074.12 and a customer has bought something for 849.12
So, together it should be 1,923.24
But unfortunately this is not the result. Instead, only the last number is taken, and the old value (1,074.12) is ignored or deleted. So the Result is 849.12 and of course this is wrong. My guess is that the comma is interpreted as a string? How can I sum two numbers in Make without having problems? Attached are a few screenshots. Thank you very much 
1,074.12 is not a number. You have to convert it to 1074.12 using the built-in function parseNumber
e.g.:
{{ parseNumber("1,074.12"; ".") }}
For more information, see https://www.make.com/en/help/functions/math-functions#parsenumber-number--decimal-separator-
3 Likes
Great, it works! Thank you very much I am happy. Have a nice day! Thank you!!
2 Likes
No problem, glad I could help!
1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
- allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
3 Likes
