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
If the records being summarized are all weighted equally then the Averages will work. But if they are entries for different quantities, then it will not work.
In that Case, you can create a table of names and have a relationship to summarize the detail data up to the summary table to get your totals.
Now that we have Automations it may be easier to keep that table updated, ie to auto create the missing records if child records get created and they have no parent.
In that Case, you can create a table of names and have a relationship to summarize the detail data up to the summary table to get your totals.
Now that we have Automations it may be easier to keep that table updated, ie to auto create the missing records if child records get created and they have no parent.