Replace null or empty in an expression with N/A

Questions
,
1

Is there a way i can replace either empty results, or null results with a “N/A”

image
image768×498 44.7 KB

I was thinking about .toString().length() something in that area, but cant think if this is correct way of doing this?

2

Hey Buddy,

I would use a ternary operator that should do the job.

1 Like
3

ty will give it a go

4

perfect, just what i was looking for

1 Like
5

I’ve been struggling to understand this for a while, and finally figured it out. I’m including my sample workflow below to show the work:

4 Likes