AnsweredAssumed Answered

Calculating the number of fields that have a particular response

Question asked by tchick on Mar 17, 2013
Latest reply on Mar 18, 2013 by philmodjunk

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

Outcomes