Report fields as table fields
I have a date field called [Field Work Complete Date]. I have a multiple choice field called [Status]. I can build a report that shows me how many field work dates are not empty. I can also bui...
Forum Discussion
In your Projects < Tasks relationship:
1. Build a Summary Count field called [Total # of Tasks] to count the # of Tasks against the Project.
2. Build a Summary Count field called [# of Completed Tasks] to count the number of Tasks where the [Field Work Date] is not equal to empty (optional)
3. Build a Summary Count field called [# of Ready for QC Tasks] to count the number of Tasks where the [Status] of the Task is equal to "Ready for QC" (optional)
4. Build a Summary Count field called [# of Complete or Ready for QC Tasks] to count the # of Tasks where the [Field Work Complete] is not equal to empty OR the [Status] = "Ready for QC"
(this would be an "any" condition in the summary field criteria)
In the Projects table, build a formula numeric field called [# of Completed/Ready for QC Tasks]:
with the formula:
[Total # of Tasks] - [Total # of Completed or Ready for QC Tasks]
1. Build a Summary Count field called [Total # of Tasks] to count the # of Tasks against the Project.
2. Build a Summary Count field called [# of Completed Tasks] to count the number of Tasks where the [Field Work Date] is not equal to empty (optional)
3. Build a Summary Count field called [# of Ready for QC Tasks] to count the number of Tasks where the [Status] of the Task is equal to "Ready for QC" (optional)
4. Build a Summary Count field called [# of Complete or Ready for QC Tasks] to count the # of Tasks where the [Field Work Complete] is not equal to empty OR the [Status] = "Ready for QC"
(this would be an "any" condition in the summary field criteria)
In the Projects table, build a formula numeric field called [# of Completed/Ready for QC Tasks]:
with the formula:
[Total # of Tasks] - [Total # of Completed or Ready for QC Tasks]