Average of days task was open

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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.
Photo of frumy horowicz

frumy horowicz

  • 172 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
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.
Photo of frumy horowicz

frumy horowicz

  • 172 Points 100 badge 2x thumb
thanks, that worked!