My expression return "Red dot" or "-"

[paulyeo11]

Hi All

My expression below will return Red Dot or "-" :-

If([Dashboard Metric_SOURCE_]='Sales vs Last Year',

if

(

(

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} REVENUE_/1/1000)

-

sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} REVENUE_/1/1000)

)

/

sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} REVENUE_/1/1000)

< 0,'qmem://<bundled>/BuiltIn/led_r.png'

)

,

My question is instead of it display "-" , how to make it display as blank ?

Paul

[paulyeo11]

picture more then thousand word

[#3 · Accepted solution]

'-' Is the equivalent of NULL.

To change this to blank, go to presentation tab of chart and at bottom left, change the Null Symbol to a space character.

[tresesco]

Probably you can put a space withing quotes in the ELSE part of your expression. That is a a string '  '.

Thanks.

[paulyeo11]

Hi Nigel West

Your approach work fine , which i don't need to create another else syntax. Thank.

Paul