AnsweredAssumed Answered

Calculate Sum of Field in Found Sets

Question asked by BradenDouglass on Aug 10, 2011
Latest reply on Aug 10, 2011 by philmodjunk


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!