I've got an Object with a number of fields which take Averages of values connected records. However the averages I was getting seemed off, and after much patient testing I found that the Average computation was ignoring the value in the most recently added connected record. This problem also affect Sum and Minimum fields (in my app at least) but not Count fields.
I've tried raising this with Knack but haven't heard back from them yet.
I'm interested in whether this problem is due to:
- A bug in Knack (seems unlikely, but...)
- A design flaw of some kind in my app.
I'm interested in any kind of fix or workaround.
Appreciate any suggestions...