Color coding with Full Accumulation expressions is not as expected

[nenadvukovic]

Hi,

Can you please take a look into the provided example and help me fix this issue. I would expect to see the second bar colored in red, and it is colored in green because the period 2 is green, but cumulative it is red.

Here is the screenshot and the test qvw file attached.

Thanks

[sunny_talwar · Accepted solution]

Try this for background color

if(RangeSum(Above(sum(Measure1) + sum(Measure2) - sum(Plan), 0, RowNo())) < 0, lightred(), lightgreen())

[nenadvukovic]

Great Sunny. Thank you