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?