Currently, the "Formula" tab allows only numeric calculations (for ex.: 10,000 Factory hours * 0.25 Factory Support Metric = 2,500 Factory Support hours).
Could "Formula" be enhanced to allow calculations referring to the contents of other Task IDs? If, using the example above, the 10,000 Factory hours were contained in Task IDs 3.3.1, 3.3.2, and 3.3.3, could "Formula" be enhanced to except the expression: ( + + ) * 0.25 Factory Support Metric = 2,500 Factory Support hours).
This would have the added benefit of the formula automatically updating if the contents of one of those Task IDs changed. Staying with the example above, if 2,000 additional Factory hours were added to Task ID 3.3.1, the expression in "Formula" would automatically restate to ( + + ) * 0.25 Factory Support Metric = 3,000 Factory Support hours).
As currently constituted, "Formula" requires the user to remember to update to: 12,000 Factory hours * 0.25 Factory Support Metric = 3,000 Factory Support hours. In the 11.5th hour, there is always a risk this need gets overlooked, and incorrect data derived using "Formula" gets submitted to the Customer. Never a desirable result! :)