Issues with Sums, Counts, etc

[SteveV]

I have just posted a new thread about this issue: But you are right the Sum function has a serious bug.

WARNING> SUM Function has a Bug

The Sum function regularly fails to accurately Sum the values in relevant (filtered) records of connected Data Tables. WARNING: Updating a record that has a Sum function DOES NOT cause the Sum to be recalculated. Therefore, if data has changed in the fields to be summed it they are NOT GUARANTEED to be summed accurately. I reported the issue to Knack and they said Knack “will only update the field when any connections are added … or at the internally scheduled time for the month.” They suggest…