2 Replies Latest reply on Jan 28, 2010 12:52 PM by donjuancarlos_1

    Summary calculation - counting records



      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?