AnsweredAssumed Answered

How to get total of numbers in a textbox

Question asked by SaiAlb on Jul 10, 2014
Latest reply on Jul 11, 2014 by raybaudi

Title

How to get total of numbers in a textbox

Post

     Hi,

     Can you help me with a function to sum up the total numerical values in a textbox separated by , or carriage return e.g.

     If text contained "XS-1000, S-2000, M-3000" what kind of calculation to use to output a value of 6000?

     I tried and I am stuck at.

     Let(I=PatternCount(text; ",") + 1; Filter(LeftValues(text; i); "1234567890"); i = i -1)

     but it only outputs 100020003000

     I appreciate your time and help, thank you.

Outcomes