Extract numerical values to find total sum from string

Topic Labels: Formulas
564 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Screenshot 2021-05-30 183756

I am new and teaching myself databases and AirTable so please be gentle. :grinning_face_with_big_eyes:

I am trying to extract the numbers from the {Recipe} column and add them all together to figure out the total number of drops for each blend. Is it possible to do this with my current setup? I have figured out how to extract the numbers but it just smooshes the numbers to become a 2-6+ digit number.

I hope this makes sense.

1 Reply 1

Yes, use Value() to parse the floats. And welcome to the community!