Replacing empty cells with value

[tdr_Dinesh]

Good day,

I have created the below calculated field to replace the empty sting.

ifelse (DefectPattern =" " , “Not Specified”, Defect Pattern)

and then if verified in the dataset it shows accurately. Below is the snap.
In the visualization still shows as empty . Could some one please assist me on this. Thank you!

[Sanjeeb2022]

Hi @tdr_Dinesh - Can you please try below code

ifelse(strlen(DefectPattern) = 0, "Not Specified", "Defect Pattern")

Regards - Sanjeeb

[tdr_Dinesh]

Hi @Sanjeeb2022,

Could you please have a look in to the below error message and assist.

[Sanjeeb2022]

Hi @tdr_Dinesh - Please try this. The strlen function return integer which should be 0

ifelse(strlen({DefectPattern}) = 0, "Not Specified", {DefectPattern})

Regards - Sanjeeb

[tdr_Dinesh]

Hi @Sanjeeb2022 ,

Still experiencing the same issue.

[Biswajit_1993]

Hi @tdr_Dinesh ,

Just use this formula I think it will work for you.

Thanks & Regards
Biswajit Dash

[tdr_Dinesh]

Hi @Biswajit_1993 ,

Thank you, but still it didn’t work for me. It shows blank Cells.

[Sanjeeb2022]

Hi @tdr_Dinesh - I checked with sample data and it worked for me.

Sample data output

calculated field

Regards - Sanjeeb

[tdr_Dinesh]

Thank you @Sanjeeb2022,

Now, it is working fine. Initially I missed the closing bracket parenthesis.

Thanks for your assistance.

[Sanjeeb2022]

Thanks @tdr_Dinesh . Good to hear the issue is resolved.

Have a great week ahead.

Regards - Sanjeeb