Convert list of numbers from LongText field to number

[Grover426]

Help Appsheet experts, I'm trying to convert a list of numbers in the LongText field to a number, I tried using this formula EXTRACT("NUMBER", [Quantity]), the quantity field has a list of numbers on each line but it is in text format when trying to apply the formula it only converted the first number in the list but not the rest, any suggestions or contributions for this case I would be very grateful. 

[Steve · Accepted solution]

This looks like a bug. Please contact AppSheet Support for help with this.

Attn @AleksiAlkio 

[KON_TROLL]

Well its not possible to make a list set to TEXT in Appsheet , to behave like a list of NUMBERS everywhere. Then you must change the Data Type to DECIMAL or NUMBER

But the solution is to use NUMBER() around those other places you use the data form this list. That should work fine.

[Suvrutt_Gurjar]

@KON_TROLL has guided well.

If you could share a sample of that column' contents, the community could suggest better on the feasibility.

[Grover426]

I would like to apply the expression EXTRACT("NUMBER", SUM([quantity])), in the Total formula, I am a newbie at this, these are my first experiences in Appsheet, excuse me, but my idea is to convert the sum of the Quantity field to the Total field, please if anyone has gone through this, give me a guide on how to solve it.

@KON_TROLL I tried to try like this, or is it another way sorry if I didn't do the right thing

 When I save with the formula the Total field disappears from view

[Steve]

SUM(EXTRACTNUMBERS([cantidad]))

[Grover426]

thanks, 

SUM(EXTRACTNUMBERS([cantidad]), just get the first one back. I would like you to do the sum which would be 110

[Steve]

I dunno. It worked for me.

[Grover426]

With some kind of payment plan or prototype.

Another way I was trying was to put the + sign after each number, it adds it up, but putting the operator for each number seems tedious to me

[Steve · Accepted solution]

This looks like a bug. Please contact AppSheet Support for help with this.

Attn @AleksiAlkio 

[Grover426]

Thank you for your attention and advice. I will try to find a way to solve it.

[AleksiAlkio · Accepted solution]

It seems that if you don't have anything other than space between your numbers, the EXTRACTNUMBERS() doesn't recognize them except the first one. That's why the "+" helps.