AnsweredAssumed Answered

Multiple field totals in summary report

Question asked by steeley on Sep 9, 2009
Latest reply on Sep 9, 2009 by mrvodka


Multiple field totals in summary report



When I set up my order entry many years ago, I created separate fields
for each invoice line item (qty1, item1, qty2, item2, etc). It seems
more efficient to do this with a portal now, but I'd still like to work

with the data I have.

Creating a summary field for qty1, I can get a quantity total of all products
entered in item1 (sorted by the item number field in my product database),
but I would like a report with the combined quantity total of all items in
both item1 and item2.

Is it possible to add reports or does anyone have a suggestion to accomplish this.

Any help is appreciated.