Grouped Bar Chart, 2 Measures with different colours

[itatspectrum]

Hi All,

I'm looking to colours the bars on the chart below, however when I apply my formulat

that looks like if(sum(YTD)>sum(LYTD), Green(), Red()), however it apllys the same colur to both bars when I apply it.

I'd be happy to get Green or Red for the YTD and LYTD as gray or blue.

Cheers

Steve