Question Re: IF ISNULL() in Technology Q&A

IF ISNULL()

Former Member — Thu, 07 Mar 2019 10:12:37 GMT

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 — Thu, 07 Mar 2019 10:13:19 GMT

try this.

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

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

Former Member — Thu, 07 Mar 2019 12:04:04 GMT

Thanks Amit!