Show No data to display when the first expression is null in gauge Chart

[#1]

I have a gauge chart with two expression

the frist expression result is base on the second expression

what i want to do is display 'A error message with No data' instead of display the empty record

it can show error message with No data if both expession is empty automatically

but i can't do it if only expression1 is empty

[brenner_martina]

Hi, Kenny,

there is only 1 expression for a gauge chart allowed, because gauge shows only 1 number.

[#3]

ya .i would like to show 1 expression only ,if it was null , then display no data

because my expression is too complicated ,so i need to seperate it with two expression to make it clear

for example:

expression1  <--- for display

if isNull(columnB ), null(),

     if (columnA>columnB,columnA,columnB) )

columnA:

Avg(Sale)

columnB:

sum(Sale)/10