IF STATEMENT LABEL NOT "-"

[FinancialDataScientist]

Hi All,

I'm trying to label a pie chart and I'd like it say "None" rather "-" when there is no data. My current formula for the data field is:

if(quartile='1','1st Quartile',if(quartile='2','"nd Quartile',if(quartile='3','3nd Quartile',if(quartile='4','4th Quartile')))).

I've attached a picture in case that helps.

Thanks in advance guys!

[Anil_Babu_Samineni]

Try this

if(quartile='1','1st Quartile',if(quartile='2','"nd Quartile',if(quartile='3','3nd Quartile',if(quartile='4','4th Quartile', 'none'))))

[FinancialDataScientist]

Hi Anil, I have tried this but the it seems to still count a a number of entries as "-" rather than none on the pie chart. Do you know how to fix this?