The Job Cost Spreadsheet by Date Range report is a transaction driven report by “cost type”. When adding Units and Unit Cost you will need to create a formula to specify the cost type of the transaction. For example, the Formula for Total Material Cost on the  (found under Tools>Total Material Cost> ) Is ASUM(Cost Code(JC Transaction), IF(Cost Trans Condition (Design Formula) AND Accumulate As Lkup (Design Formula) = “Material”, Amount (JC Transaction) – Non costed tax (JC Transaction))) This forumula is used on the col Material for the total cost, it isolated the tran type of "Material"

In essence you will need to isolate the transaction type with a formula for each unit and unit cost and then drop the formula onto appropriate column on the report.

I hope this helps.

robg- Thanks for your response but I don't understand.  I was able to add the columns for the units & unit costs by using this response from Rhonda V..............."For the Labor Estimate:  Copy the existing design formula named "Total Labor Estimate" and name the copy "Total Labor Est Units" as the new formula.  Change the new design formula "Total Labor Est Units" by changing Amount (JC Transactions) to Units (JC Transactions) =this is at the end of the formula.  Then create a new formula named "Unit Cost per Est" which will be Total Labor Estimate (design formula) / Total Labor Est Units (design formula).  I think this will work for each category such that copying existing formula and changing the "amount" to "units" in JC Transactions and then dividing the 'amount formula' by the new 'units formula' you will have the unit cost and/or cost per unit." ....................  I don't understand how you response helps me with converting hours to "Square Yards" for example.  Please excuse my ignorance for not understanding.  Is there anyway that you could explain this by using an example of "hours" in payroll?  Or were you trying to help me with adding the columns for units & unit costs and not touching on the hours conversion issue?

robg- Thanks for your response but I don't understand.  I was able to add the columns for the units & unit costs by using this response from Rhonda V..............."For the Labor Estimate:  Copy the existing design formula named "Total Labor Estimate" and name the copy "Total Labor Est Units" as the new formula.  Change the new design formula "Total Labor Est Units" by changing Amount (JC Transactions) to Units (JC Transactions) =this is at the end of the formula.  Then create a new formula named "Unit Cost per Est" which will be Total Labor Estimate (design formula) / Total Labor Est Units (design formula).  I think this will work for each category such that copying existing formula and changing the "amount" to "units" in JC Transactions and then dividing the 'amount formula' by the new 'units formula' you will have the unit cost and/or cost per unit." ....................  I don't understand how you response helps me with converting hours to "Square Yards" for example.  Please excuse my ignorance for not understanding.  Is there anyway that you could explain this by using an example of "hours" in payroll?  Or were you trying to help me with adding the columns for units & unit costs and not touching on the hours conversion issue?

Ronnie, I was explaining from the point of view of writing the formula from scratch. RhondaV is better, she borrowed the existing formula and modifeid by changing the amounts to units, for the converstion. The formulas are desinged to isolate the transaction by cost and category. Her idea is excellent and simplier.

Another option may be to use Production Units on your cost codes. Production units are used to track job progress by cost code and are updated through Enter Misc Worksheets. You could then add these fields to the report to see the total productions units.

You can read more about how Production Units work in the Job Cost Help Topics by entering "Production Units" on the Index tab.

Great Question!