Help Needed

[#1]

Hi,

   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

Eg:

Rule   FAN Actual Incentive

1        A       100

1        B        100

I have now

Rule   FAN Actual Incentive

1        A       100

1        B        100

1        C        -

1        D        -

I want to fill the null values with 100.

[#2]

Hi Kakarotto

Try something like:

=only(Total <Rule> ActualIncentive)

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"

Hope this helps

Erica