A set is calculated for an entire chart, not for a row of the chart. The same is true of dollar sign expansion. So your $(=sum(Value)) calculates the total value. This total value is much higher than your table allows, so there are no RGB values to be found. Even if it found one, it would apply the same value to every bar in the chart.
You'll want to do this without set analysis and without dollar sign expansion if you want a different color for every bar.
These seem to work, if I understood what you want. There might be a simpler solution.