Set Analysis Expression issue

[berryandcherry6]

Hi,

I have a Expression

Count({$<DateType={completion},final_test_status={"passed"},

YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"}>}invitation_id)

For this i am adding to filter it by  Canonical_Month={'Month_Last_Canon_Year'} .

Canonical_Month    Month_Last_Canon_Year

       Jan                                 May

       Feb                                 June  

      MAr                                  July

       Apr                                  Aug

      MAy

      June

       July

       Aug

        Sep

        Oct

        Nov

        Dec

So my expression becomes 

Count({$<DateType={completion},final_test_status={"passed"},

YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"},Canonical_Month={'Month_Last_Canon_Year'}>}invitation_id)

But  this Canonical_Month={'Month_Last_Canon_Year'}  is not getting applied. Count gives Zero.

Please help me on this.

[berryandcherry6]

Hi,

Check this