Skip to main content
Question

Average of days task was open

  • Jul 20, 2017 10:12 PM UTC
  • 0 replies
  • 25 views

I have a situation where I have two tables,

1- tasks
2- vendors


There is a one to many relationship where each vendor may have many task.
In the tasks form I have a field that calculates days it took to complete that task. (numeric) how do I pull that information into the vendors report, so that an average of how long it took the vendor to complete his assigned tasks will appear.
This topic has been closed for replies.

  • Author
  • Observing
  • Jul 21, 2017 8:32 PM UTC
You'll need to build a Summary Field from within the relationship between the tables. When you open up the relationship, select the Add Summary Field button at the bottom left and it will walk you through the steps.

  • Author
  • Observing
  • Jul 27, 2017 7:11 PM UTC
thanks, that worked!