Hello all,

I have and order line item table that for each line item record there are three distinct quantities and prices (based on product grade). If there was only one quantity and price I could run a SQL Select - Sum statement to sum all records for a particular Order; however, when I try multiple sum statements within one SQL Select I get an error.

Does anyone some ideas on how to approach this problem?

TIA