I can replicate what you are trying to do with the following provisos:
1. The calculated number (gEndingBalance) needs to be an unstored calc, not a global
2. I created a script to set two global variables, and another script to clear them
3. Each script needed to have the step Refresh Window [ Flush cached join results ] in order to update the result field
Over to you.
The unstored calculation did the trick.
Thank you for 'shedding some light' my way.
Hmm,I said it on previous thread.
Changing global calc field to not global, it becomes unstored since the calc expression contains global field.
Kewl! Thanks Joshua for the link. It is in my Filemaker Bookmarks for future reference.