Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try it with: if(len(trim('$1'))=0,'Null','Not Null')
- Marcus
What does the $1 parameter contains?
I tell you in the original question
It did the same thing.
I even tried if(IsNull(trim('$1')),'Null','Not Null')
still the same result
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
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.
Can you post image of your parameters?
I have it figured out and am going to do a full Blog Post as this took a lot of research.