Null condition in color expression

[#1]

Hi, I have two measures, Test and Compare. I want to change the color of my chart based on whether Test>Compare or not. However there are some null values in Test.

My expression if(sum(Test)>sum(Compare),red(),green()) does not work because of the null values in Test. Is there a way to add the null condition into my if statement?

Thanks.

[sunny_talwar]

You may be able to something like this?

If(Len(Trim(Sum(Test))) = 0, Blue(), If(Sum(Test) > Sum(Compare), Red(), Green())

Best,

Sunny

[MK_QSL]

what is dimension and expressions in your chart?

[#4]

Test and Compare are both measures in my chart. Name is the dimension.

[#5]

Hi Sunny I tried this but it did not work...

[sunny_talwar]

Can you share a sample or show screenshots?

[MK_QSL]

You mean to say...

Dimension

Name

Expression

SUM or COUNT or some function (Test)

and SUM(Compare)

You want to change color of both chart?

kindly clarify on this!

[rwunderlich]

‌nulls should be treated as zero by sum(). What happens if you put sum(Test) in a text object?

Rob

[#9]

Use the Visual Cues option in the Chart.

[#10]

Hi Manish, it is just one chart. Sum(Test) and Sum(Compare) are measures of the chart and Name is the dimension. It is a scatterplot. I want to change the color that when Sum(Test)>Sum(Compare), show me red, and otherwise green. There are null values in Test that is messing up the condition. Thanks.