Is there a way to create a formula that will take the first value in a group and then distribute that value to the other values in the group. For example:

Currently Displayed like this:

Source    Yes Count     Cost
ABC          1        100.00
ABC-1        6          0.00
ABC-2        3          0.00

Want it to look like this:

Source    Yes Count     Cost
ABC          1          10.00
ABC-1        6          60.00
ABC-2        3          30.00

FYI, I need these to display in group footer 2. Any help would be appreciated. Thank You.

-Neal