4 Replies Latest reply on Jul 11, 2014 2:09 AM by raybaudi

    How to get total of numbers in a textbox

    SaiAlb

      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.