2 of 2 people found this helpful
You have to aggregate your calculation.
Change Color Code to:
if SUM([Score])>SUM([target]) then "Green"
ELSEIF SUM([Score])>0.8*SUM([target]) then "Yellow"
When the calculation is not aggregated it is evaluating everything at the row level, creating ad-hoc categories for your lines. When you aggregate the calculation, it evaluates the calculation at the same level as your Rows and does not separate the line.