Test if null in Expression

[djbloiss]

I am passing Variables to my expression and I want to test if the value is null, so I can do something different depending on if it is Null or not.  How can I test if the variable is null?  This is currently what I am testing:

if(IsNull('$1'),'Null','Not Null')

then I am calling it like this:

$(Testing($(Test)))

or this:

$(Testing)

In either case it is returning Not Null. 

[marcus_sommer]

Try it with: if(len(trim('$1'))=0,'Null','Not Null')

- Marcus

[Anil_Babu_Samineni]

What does the $1 parameter contains?

[djbloiss]

I tell you in the original question

[djbloiss]

It did the same thing.

I even tried if(IsNull(trim('$1')),'Null','Not Null')

still the same result

[marcus_sommer]

Please provide some more details what do you want to do. I assume that you want to nest parametrized variables. This is in general possible but not trivial from a syntax point of view:

- Marcus

[djbloiss]

Marcus, I don't want the full answer because I am new and I am trying to figure things out on my own.  Getting the full answer will not help me much.

[Anil_Babu_Samineni]

Can you post image of your parameters?

[djbloiss]

I have it figured out and am going to do a full Blog Post as this took a lot of research.