M
mvgoedken
I ran a query with the following results:
Customer PO Price Handling Freight Tax
111 10 3 2
111 8 2 1 2
112 15 5 4
112 22 6 5
112 8 1 2 7
115 9 2 1
115 13 3 3 4
In a new column, I would like to calculate the sum of the "Price",
"Handling", and "Freight" fields for each group of records having the same PO
number. Is this possible?
Next, I'd like to compute the ratio of tax to the total I just calculated.
(Tax/(Price+Handling+Freight)
Customer PO Price Handling Freight Tax
111 10 3 2
111 8 2 1 2
112 15 5 4
112 22 6 5
112 8 1 2 7
115 9 2 1
115 13 3 3 4
In a new column, I would like to calculate the sum of the "Price",
"Handling", and "Freight" fields for each group of records having the same PO
number. Is this possible?
Next, I'd like to compute the ratio of tax to the total I just calculated.
(Tax/(Price+Handling+Freight)