IF ISNULL()

[Former Member]

Hi All,

I have a variable and would like to include the ISNULL() function to return "N/A" if empty. Current this is how my variable is setup:

=[Content] Where ([Name] = "Business Area")

I tried the below but does not like the 'WHERE':

=IF ISNULL([Content]) then "N/A" ELSE [Content] = Where ([Name] = "Business Area")

Any suggestions on what I am doing wrong?

Thanks

[amitrathi239 · Accepted solution]

try this.

Var1=[Content] Where ([Name] = "Business Area")

=IF ISNULL([Content]) then "N/A" ELSE [Var1]

[Former Member · Accepted solution]

Thanks Amit!