Need Help With A Simple Running Total

[The Professor]

Hi All,

I have an actor's auditions database that I would like to display a running total of auditions for a given actor. This needs to be in the regular list view and not as a grand summary part, report or portal. It also needs to be global, not just for the found set.

The current list view simply has the actor's name, audition date, location and type. I'd like one more field at the end of this row that shows how many total auditions that actor has. Just the total number of records with a given actor's full name, but I don't know if I need a self join or a get function of some kind.

Thanks in advance, this forum has been a lifesaver for me.

[dbruggmann]

If you have set up everything in one table, you need a self join; otherwise a relationship between Actors and Auditions. In any case the relationship would be between the actors name fields. Then define a calculation field with the aggregate function Count()

c_auditionsNumber = Count(NameOfTheSelfjoin::NameOfAnyAuditionField)

[The Professor]

Thanks, dbruggmann! That worked perfectly.