Attribute Assistant - delayed field update

[BrynMorris-hale]

Hi - I'm looking for some help with my attribute assistant updates. It seems they are delayed or one step behind.

I'm using a Feature Stats Value method to sum a number of columns together. These are quarter totals for the year and the result is a year figure. This is working fine. I then have another Feature Stat that sums all of these year totals to get a final figure. However this doesn't updated straight away, it seems only after I have entered another value does it update based on the first value entered, so it always seems to be one step behind. 

I've tried changing the weighting and putting the final sum to the end but this doesn't work. 

Interestingly when I use the attribute assistant toolbar and 'run change rules for selected features' it updates and corrects everything and it works fine.

I've attached my dynamic value table. The rules that are delayed or one step behind are OBJECTID16 and 17. Total Compl and Total Commit.

Any help would be greatly appreciated.

Thanks

[MikeMillerGIS]

Any chance you can post a GDB with the dynamic value table and the Housing_Monitoring table so I can run through this and see what is happening

[BrynMorris-hale]

Thanks Michael, could I email this to you as its confidential?

[MikeMillerGIS]

Yes, but feel free to include no data, just a schema.  I can fake out a few features.  mmiller@esri.com

[BrynMorris-hale]

thanks I've sent you an email

[MikeMillerGIS]

Bryn,

   Sorry for the delay, was out on vacation.  I reviewed the sample.  I believe the issue is with the field weight.  The higher number runs first.  So switch your feature stats for the fields to run first, meaning a higher field weight number,  I set them all to 35.  Then your summary of each year, say 30, then the final expression last, say 20.  Weights are just relative.  Like label weights.

[BrynMorris-hale · Accepted solution]

Thanks Michael, Sorry for the delayed reply. I tested that and it works! I really appreciate your help on this. Cheers.