Apex Code Development You need to sign in to do that
Don't have an account?
hickmand Field Update Formula Problem
I have a field "Margin" that is populated via a field update formula that is part of a work flow rule. This method is used because the underlying formulas were too long to put directly into a formula field.
The underlying field update formula refers to two other fields ("Total Premium" and "Risk Premium") that are also updated via a work flow driven field update formula.
Problem: Wnen the "Margin" field updates, it does not populate with the current information, it uses pre-update data. Its almost as if "Margin" field update rule runs before the other field update formulas and as such, puts in old information. The intersting thing is that the underlying update driven fields "Total Premium", and "Risk Premium" populate correctly. There must be some rule around the order in which field updates occur.
Can anyone assist with this problem?
Darin
Workflow rules update in a virtual "parallel" mode; they are all considered to have executed simultaneously. This has the effect of any field update not being able to "see" changes made by other field updates in the same transaction. There is no order of operation that will allow you to do this in a single pass.
Consider a "trigger" instead to update all the fields, or have the Total Premium and Risk Premium fields be updated by the Field Updates, and the final field be a formula.