AnsweredAssumed Answered

Summary calculation - counting records

Question asked by donjuancarlos_1 on Jan 28, 2010
Latest reply on Jan 28, 2010 by donjuancarlos_1


Summary calculation - counting records


I have a field that contains the username of a user assigned to an active job (AssignedName).  I want to create a calculation field that counts the number of active jobs a user has and displays the number in a field. I would then display it thus:


"You currently have <<Jobs::CurrentJobCount>> jobs to which you are assigned."


I would have to do some sort of count where  AssignedName = Get (AccountName)


What is the calculation to do this?