Table error

I’ve concated the % symbol to the data , it’s applied to the null values as well
How do I remove it?

Hello Vysh,

Why in the first place you want to concat the symbol % and not use the built in fomat percent option ?
image

Thanks.
Cheers,
Deep

Hi @Deep
I have a parameter called Decimals
I want the decimal places of the data to dynamically change with the parameter so I’ve used concat instead of formatting it to %

Hello,

May be you could handle first the null or empty values by using conditional expression and replace it with 0.

I guess 0% is ok and better than just % ?

cheers,
Deep

But is there no way I can leave it blank as it is?

Hi @Vysh27
you can add an calculation. Something like (short version):
Ifelse(isNull(value),Null,concat(value,"%"))
BR

1 Like

Thanks @ErikG , It worked

1 Like