Doing an average
If you have a single table with a "weight" field, how do you do an overall average on that field?
The documentation seems to say that Average is only for hard coded values or fields in a related table.
I've tried to create a separate table occurrence and constuct the average that way, but it still doesn't work.
Assuming this average can even be done, would it be better to create a calculation for a field or put a button on the layout that runs a script (or maybe it doesn't matter)?
My references don't help on this one.
Thanks in advance.