[Resolved] average cost

[nikko50]

Hello there. I'm trying to calculate average cost.
I have 1 table called 'receiving' .In this table there are 2 fields called 'itemid' and 'unitcost'. How can I go about using a SELECT statement to calculate average cost if I have multiple rows of 'itemid' and 'unitcost'. Any help as how I can go about this would be awesome🙂
Tracy

[drawmack]

SELECT (SUM(unitcost)/COUNT(itemid)) as avg_cost FROM receiving

[nikko50]

Anyway I can combine these statements into one. The first sql sums all received quantity and the second statement sums all invoice totals, then the last statement is the basic math to get the average cost.

SELECT receive.quantity, sum( receive.quantity ) AS 'receivedsum'
FROM receive
WHERE receive.equipmentid = 453
GROUP BY receive.equipmentid";

SELECT receive.totalcost, sum( receive.totalcost ) AS 'totalsum'
FROM receive
WHERE receive.equipmentid = 453
GROUP BY receive.equipmentid";

$average=totalsum/receivedsum;

[nikko50]

Problem resolved. Thanks for the help guys🙂
Tracy