Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a product table , by this i need to find the cost of goods sold.
Product:
LOAD ProductID,
Name ,
ProductNumber,
MakeFlag,
FinishedGoodsFlag,
Color,
SafetyStockLevel,
ReorderPoint,
StandardCost,
ListPrice,
Size,
SizeUnitMeasureCode,
WeightUnitMeasureCode,
Weight,
DaysToManufacture,
ProductLine,
Class,
Style,
ProductSubcategoryID,
ProductModelID,
SellStartDate,
SellEndDate,
DiscontinuedDate
FROM
E:\Task\Excel\Product.xlsx
(ooxml, embedded labels, table is Product);
How i can Get the Cost Of goods Sold, i can not understand which formula i need to use
Please help me.
Hi there,
You will probably need to have a word with your finance department as they have different ideas about things (and might add more info in than what you have).
However I would have it as the sum of the [standard cost] field for products that have been sold. Do you have another table with sales in?
Erica
Hi Need Help,
I think this is a question best directed towards whoever collected the data for you. Its not really a matter of formulas at this point for you, its more a matter of what your fields actually represent