formula to total then divide field
I have what seems like should be an "easy" problem to fix. I just cannot figure it out. But I know someone has ran into it before so I reach out to the oh-so intelligent community :) I have a sum...
Forum Discussion
With a single record you create s new table and add 1 Record. Maybe the table would be called
Set Analysis Period.
It will be Record ID# 1.
Then on the details table make a field called [link to set dates] with a formula numeric formula of
1
Make a relationship to the single record table based on that field, and lookup the dates down to the detail records.
You can then use those lookup fields in you summary totals fields where you are summarizing total hours and total completes.
Set Analysis Period.
It will be Record ID# 1.
Then on the details table make a field called [link to set dates] with a formula numeric formula of
1
Make a relationship to the single record table based on that field, and lookup the dates down to the detail records.
You can then use those lookup fields in you summary totals fields where you are summarizing total hours and total completes.