AnsweredAssumed Answered

Counting occurences of a value

Question asked by SS_2059 on Jan 26, 2012
Latest reply on Jan 26, 2012 by 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--