Skip to Content
0
Mar 07, 2019 at 10:12 AM

IF ISNULL()

202 Views

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