Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Extract numerical values to find total sum from string

Topic Labels: Formulas
354 1
Showing results for 
Search instead for 
Did you mean: 

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!