Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
'-' 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.
picture more then thousand word
'-' 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.
Probably you can put a space withing quotes in the ELSE part of your expression. That is a a string ' '.
Thanks.
Hi Nigel West
Your approach work fine , which i don't need to create another else syntax. Thank.
Paul