AnsweredAssumed Answered

Calculating number of records matching specific criteria

Question asked by RyanMcCoy on Nov 7, 2012
Latest reply on Nov 8, 2012 by philmodjunk

Title

Calculating number of records matching specific criteria

Post

     Just a quick simple one for you guys this time.  Basically I am attempting to generate a report of an inventory system that allows me to calculate the total number of items that have a matching field.  For example, I want the field "totalFresnels" to count the number of times the word "fresnel" appears in the table Inventory::instrumentType.  I am assuming I define the "totalFresnels" field as a calculation field and evaluate the number of times "fresnel" appears in the Inventory::instrumentType field, I am just not sure of the context of how to use it.  Any advice?

      

     Thanks!

Outcomes