5 Replies Latest reply on Jan 26, 2012 5:52 PM by SS_2059

    Counting occurences of a value

    SS_2059

      Hello, all--

       

      I'm trying to count the number of times a name appears in a portal. The cOccurence field in the attached example file illustrates how I'm accomplishing this. But there's a problem when a child record is moved from one row to another.

       

      For example, here's my starting point:

      Screen shot 2012-01-26 at 2.58.24 PM.png

      And here's what it looks like after I've swapped rows 5 & 6:

      Screen shot 2012-01-26 at 2.59.56 PM.png

      I need cOccurence in the 5th portal row to now return a value of 2, and I need cOccurence in the 6th row to return 3. What is the best way to accomplish this?

      Any suggestions greatly appreciated. Thanks very much--