Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this for background color
if(RangeSum(Above(sum(Measure1) + sum(Measure2) - sum(Plan), 0, RowNo())) < 0, lightred(), lightgreen())
Try this for background color
if(RangeSum(Above(sum(Measure1) + sum(Measure2) - sum(Plan), 0, RowNo())) < 0, lightred(), lightgreen())
Great Sunny. Thank you