Sum of values stored as string (0,27)

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!! :man_facepalming:

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 (

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 (

and here is the solution digested for you.

  |> map(fn: (r) => ({ r with _value:  strings.replaceAll(v: r._value, t: ",", u: ".") }))
  |> toFloat()