Calculating material costs from unit costs and quantities used in a daily report is made easy using a math formulas.
To start, navigate your cursor to the left tab and choose 'Default' table under 'Table'. A default table is usually used for a material cost/total in a daily report. The table should closely look like this:
Material | Quantity | Unit Cost ($) | Total |
(Drop down list) - A1 | (Number Field) - B1 | (Number field) or (Formula that autopopulates value when a material is chosen) - C1 | (Formula field) - D1 |
To calculate the material cost, use the formula in cell D1,
=B1*C1
Note: In filling out your form, when you click on '+' to add more entries the formula is automatically populated to the next row under colum D (D2, D3, D4,...Dn).