Can you spot the error in my multi-row formula?

[HelenL]

Line 3 works perfectly.

Why is it not recognising "Null" in Line 1 and 2.

Media and Magazine fields are both String. 

Thanks for looking 🙂 

[HelenL]

Thanks for your quick reply.

I tried this but got the same result.


IF ([Media] = "Media" AND IsNull([Magazine])) THEN "Media"
ELSEIF (IsNull([Media]) AND [Magazine] = "Magazine") THEN "Magazine"
ELSEIF [Media] = "Media" AND [Magazine] = "Magazine" THEN "Media & Magazine"
ELSE "test"
ENDIF

[jasperlch]

Hi, for recognising Null Values, you will need to put IsNull([Media]), IsNull([Magazine]). By the way, you could probably use a normal Formula tool for your current formula.

[jasperlch]

That is strange as it works fine on my machine. Try using IsEmpty(Media) and IsEmpty(Magazine). IsEmpty function takes cells with a space or blank string as True as well. 

Thanks,

Jasper

[jasperlch · Accepted solution]

That is strange as it works fine on my machine. Try using IsEmpty(Media) and IsEmpty(Magazine). IsEmpty function takes cells with a space or blank string as True as well. 

Thanks,

Jasper

[jasperlch]

Hi, another suggestion is to use the Transpose + Summarize tool. The method is more dynamic if you need to work on more than one fields other than "Media" and "Magazine'.