2 Replies Latest reply on Mar 18, 2013 7:00 AM by philmodjunk

    Calculating the number of fields that have a particular response

    tchick

      Title

      Calculating the number of fields that have a particular response

      Post

           Hi, This may be a very simple thing to do but I seem to be really struggling with it. I'm trying to design a basic asset database that can calculate the number of assets belonging to individual departments, as well as to the entire company.

           I have created a field named 'department' with a dropdown list where i have specified deptA deptB deptC etc.

           Is there an easy way to create a field that calculates the number of assets that belong to deptA for example? or have i gone about it the wrong way. Would really appreciate any advice!

           Cheers