sfaust
2005-02-11, 08:17 PM
If you're doing a schedule to get a cost estimate you probably don't want to itemize every instance, you just want a count of the number of each item. Then you will want the "cost" field to calculate totals, but what if you want a column that shows unit cost as well? The "cost" field will add up the total cost if "itemize every instance" is off, so now what?
Add a calculated value called "unit cost" and make the formula =cost and uncheck "calculate totals." This new column will display the unit cost (as long as you've sorted by type or family), but the actual "cost" column will :)
Add a calculated value called "unit cost" and make the formula =cost and uncheck "calculate totals." This new column will display the unit cost (as long as you've sorted by type or family), but the actual "cost" column will :)