Stuck getting NaN trying to add numbers in a column

[sdmahaneygtjyvh]

This seems to be a popular topic. I think I’m following what has solved other people’s issues, but it’s not working and I’m not seeing why.

On this screen the user picks a list of foods and a quantity of each. The quantities and food item data are copied to a temporary table. The temporary table is being populated correctly.

On hitting the save button the rows from the temporary table are added to the end of a permanent table (I’m not even bothering with the quantities for now).

A loop runs trying to add the nutrient quantities in each column, adding each new value to the previous value. Here is where I’m adding zero to each item to force an “as number”.

Then these subtotals are written to a new row in a table of meals.

A debugging label confirms that the subtotal object is being started as a row of zeroes under the correct headers.

I’ve gone back through and checked that there are no extra characters in the source data tables - it’s just numbers. It sure looks like I’m adding zero to each retrieved value. Where else should I be looking?

[sdmahaneygtjyvh]

I managed to get through this, using the “change by” block instead of setting the current value to itself plus the new data. Multiplication by the ‘quantity’ field is now included.

I’m still just adding zero to each item to force “as number” so I don’t know why it didn’t work the other way.

And I appreciate not having to declare every variable and field, but WTF isn’t “as number” a Thunkable block?? [or, here’s a wild idea, arithmetic operations could be smart enough to interpret inputs as numbers where possible]