Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a text object on a dashboard which displays a Country field thus, =[Country]
However, if the country value doesn't exist, or is not applicable to the selection then a hyphen is displayed -
How can I replace the hyphen in this instance with a blank space ?
Thanks in anticipation
MV
=if(isnull(Country),' ',Country)
On Chart Properties->Presentation Tab ->replace the hyphen in null symbol and missing symbol by space
=if(isnull(Country),' ',Country)
Use the Function Alt,
alt(Country,' ')
Regards,
Prabhu
right click-properties-presentation then remove null symbol - and missing value - with blank and you will get it by removing the hyphen put a space and hit enter you will get blank.
Hi,
I'm confused. A text object doesn't have a Presentation tab. And I can't find the null symbol you're talking about either !
Just what I wanted. Thank you !