without seeing the code, it's rather tough to tell, but my gut says the issue is the order of the code.
I would guess that the code that perfumes the calculation is after the update record code, and it should be before.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.