AnsweredAssumed Answered

Summarizing data

Question asked by billg999 on Jul 1, 2012
Latest reply on Jul 6, 2012 by philmodjunk


Summarizing data


Hi, I have an application with, among others, a batch production table, with several lines for different batches of the same product. Also an invoice where I need to have one line for each product, with the correct total, as summarised from the production table. I have written a script which finds and sorts the relevant records, and calculates totals, but it has erorrs: some products get lost, while others still finish up with multiple (fewer than in the prod table) lines. Is there a standard method that I should use?

Thanks, Bill Groenestein