how to use IsNull webi

[Former Member]

I'm lost... don't know how to do what I need to do...

I want to be able to replace the names in one column with an abbreviation (i.e. ABCD); instead of showing the names - - but not all cells have names, some are blank, so I would expect to see blank values... I tried using the following:

=If(IsNull([NAME1]))Then "ABCD" Else ([NAME1])

and I got: ABCD in every field, even the blank fields... so, I'm stuck now...

I've also did the reverse: =If(IsNull([NAME1]))Then "" Else "ABCD"

However, when I did this, all the values are now blank...

Thoughts?

[amitrathi239 · Accepted solution]

is there any value in the Name object? all rows are blank or some only?

try this.

=If(IsNull([NAME1]) or ([NAME1]=""))Then "ABCD" Else ([NAME1])

or you can try.

=replace([NAME1];"";"ABCD")

[Former Member]

Thank you so much Kumar!!! It worked... I ended up modifying a little, but it works!!!

=If(IsNull([NAME1]) Or ([NAME1]=""))Then "" Else "LNH-FL"

[Former Member]

Thanks Kumar - - Let me try... I will get back with you 🙂