Is there an expression, to search records and find ones that are alike?
Here is what I need the expression to do:
I have various pieces of equipment, with various materials per piece of equipment.
Unit #1 has (2) 20x20x2 filters. Unit #2 has (4) 20x25x2 filters. Unit #3 has (4) 20x20x2 filters. -same as unit #1 w/different qnty. Unit #4 has (2) 20x25x2 filters. -same as unit #2 w/different qnty.
I would like to run an expression in the template, or app if easier, to search records for the filter sizes that are the same, and then be able to calculate the TOTAL filter qnty, for each size.
So in essence, having the report return something like this: Filter Sizes: 20x20x2 = (6) 20x25x2 = (6)
What would be the best way to do this? I was trying to figure out how to have the template calculate this, but if I should build a VC that calculates these, that would be fine also.