Syntax error

[bobbydave]

=sum(

        if(   

            aggr(sum({<[Control Description]={"Policy New Business", "Policy Cancellations"},

                       [Fiscal Year Month] = date(addmonths(today(), -1), 'YYYY-MM') >}

                               [Record Count]),

                       Country)=0,

                       1,0)) > 0

Can anyone see what is wrong with this code above? I want to say [Fiscal Year Month] = last month (2016-10)

[settu_periasamy]

May be try this

=sum(

        if(  

            aggr(sum({<[Control Description]={'Policy New Business', 'Policy Cancellations'},

                       [Fiscal Year Month] = {"=date(addmonths(today(), -1), 'YYYY-MM')"} >}[Record Count]),Country)=0,1,0)) > 0

[Anil_Babu_Samineni · Accepted solution]

You may forget $

=sum(

        if( 

            aggr(sum({<[Control Description]={'Policy New Business', 'Policy Cancellations'},

                       [Fiscal Year Month] = {"$(=date(addmonths(today(), -1), 'YYYY-MM'))"}>}[Record Count]),Country)=0,1,0)) > 0