topic Re: IF STATEMENT LABEL NOT "-" in App Development

IF STATEMENT LABEL NOT "-"

FinancialDataScientist — Sat, 16 Nov 2024 17:33:48 GMT

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!

Re: IF STATEMENT LABEL NOT "-"

Anil_Babu_Samineni — Wed, 27 Jan 2021 21:01:37 GMT

Try this

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

Re: IF STATEMENT LABEL NOT "-"

FinancialDataScientist — Thu, 28 Jan 2021 15:35:44 GMT

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?