Calculate Sum of Field in Found Sets
Hmm, so I have done a fair amount of searching and not sure if I have found an answer to this. What I want to do is to sum a field from each found set together to acquire a "grand total" of sorts for the specific found set.
I basically need a way to sum up a set of "lots" that all relate to an order (order number - lot number) to compare to another number (this is the easy part). Found sets seem to be the easiest way to separate the specific lots that are linked to an order. If there is a better way, definitely up for it. Thanks!