Hi @ all
I think i have a very simple problem but i don’t find the right solution for this.
I store the price for daily consumption in my database as this value ‘0,27’ and ‘0,43’ … and so on.
Now i want to sum these prices to get the total for a week, a month , a year.
I have tried it with sum but every time i get an Error because that the value is a string.
Here are the raw data and the query:
Hope somebody can help me
4 days no answer!! 
In the community’s defense you should be capable to figure it by yourself if you readed the documentation.
there is a function to convert strings to floats:
float() function | Flux 0.x Documentation (influxdata.com)
however your number has a semicolon instead of a dot, so you need to get rid of that using replace function
strings.replaceAll() function | Flux 0.x Documentation (influxdata.com)
and here is the solution digested for you.
|> map(fn: (r) => ({ r with _value: strings.replaceAll(v: r._value, t: ",", u: ".") }))
|> toFloat()
