9 Replies Latest reply: Feb 11, 2016 12:38 PM by Alejandro Fernandez RSS

    Using Rangesum() on a single field?

    Alejandro Fernandez

      Hi everybody!

       

      It's posible to use Rangesum() on a single filed that contains comma separated values?

      E.g.:

       

      Having this values:

      IDValue
      ABC,50,30
      EFG,10,30,20

       

      Use:

      LOAD

           ID,

           Rangesum(Value) as NewValue

      Resident...

       

      To get  

      IDNewValue
      ABC80
      EFG60

       

       

      I've tried but the Sum always is zero!

       

      Any ideas?

       

       

      Regards