How to sum these lines
Hi,
I have below table with total amount and I am going to sum each column. Do you know how to sum Invoice Total Amount, Invoice Tax Amount and Invoice Line Amount by one sql query? Thank you.
Invoice NumInvoice Total AmountInvoice Tax Amount Invoice Line NumInvoice Line AmountA10017113A10017245A10017325B200341120B20034246C300511200C30051249Total600 102 600
I tried to sum them but for Invoice Total Amount I only need to sum as 100+200+300.
0