Variables

[Eli181]

Hi.

I have the following issue. 

I created a pretty complex variable $(zComplex) that I would like to use in a Measure's expression ... such as 

Consider the value of $(zComplex) only if the Date is greater than 1/1/2020.

I tried

if(Date>='01/01/2020',$(zComplex),null()) ... but I get a nil outcome. 

I neither want to use a modification in the data editor, nor to use set analysis in the actual code of the variable.

Could you please help?

Thanks

[Lisa_P]

What expression is inside your variable ?

[Eli181]

Several set analyses expressions embedded in distinct counts

[Lisa_P]

It is hard to understand the issue if we can't see the whole picture

[Eli181]

Happy to set up a webex if you could and if I would not take too much of ur time

[Lisa_P]

Sure, I have time now

[Eli181]

Hi. Am on the east coast and did not reply to your latest message. If you would have some time between now and 6:00pm EDT, I could send a link for a quick vdo conf. Again, I don’t want to take too much of your time. Thanks

[Lisa_P]

Sorry, was not checking over the weekend. I am in Sydney, Australia, so my daytime is best