Set Analysis condition on variables

[#1]

Hi,

I have this variable : vtodaymonth=MonthName(today())

And I want to create another variable that would count the non null date field given that these date's month match the current one.

So I created :

vdate1=count(distinct{<[monthDate1]={'=$(vDOtodaymonth)'}, [monthDate1]={'*'}-{''} >} [Report])

But I don't get any relevent results. Could you please help me?

Thank you very much

[sunny_talwar]

Hahahaha I never saw that the two fields are the same. Good catch

[#3]

Works perfectly now! thanks guys!

[sasiparupudi1]

Great, please select correct and any helpful answers and mark this thread closed