I have a starigh table with Actual Incentive amount for certain Rule Id's. Now I want to fill the actual to all projected values for same Id. Basically in a straight table if the value ebists in the column I want to fill all fields with the same value. Any method to do this will be appreciated. Thanks
as an expression. This would look for a single value in ActualIncentive for A particular rule, and populate it for all FANs, regardless if the FAN value is null. If you are after an average of the existing values, replace "only" with "average"