I have an orders table that records all of the orders we get. Each line item on the order gets it’s own record on the table. I have a field in that table that is order ID which is the same order ID for each line item in an order.
I’m trying to get a count of the number of times an order ID appears. So if a customer orders three items I’ll have this field return “3” so that I know there are three items on this order. I can’t do a rollup or a count since order ID isn’t a linked field.
Basically I just need a count of how many times a value repeats in a field.