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

    Summary calculation - counting records

    donjuancarlos_1

      Title

      Summary calculation - counting records

      Post

      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?