Recoding data labels

Hi, I’ve created a calculated field to rename my data labels from 1, 2, 9 to yes, no, unknown. However, I am also wanting to rename null to “missing”, but my script seems to have an error in it. I’ve tried various combinations to get it to work, but haven’t had any success.

image

Thanks.

Hi @jotg :

Please try with IsNull function and also declare the else value. Below is the example
image

Hope this helps!

3 Likes

@MadhuB Thank you. That worked. :slight_smile:

2 Likes

Thanks for providing the solution @MadhuB! Thanks for letting us know that it worked, @jotg!

1 Like