Calculating the number of fields that have a particular response
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!