Expression error

[Anonymous]

What's wrong with the below error? Cannot seem to correct the error.

=avg(aggr(AVG(if(ASSIGNED_STATUS = 'NEWLY ASSIGNED MEMBER' AND TEN_PERCENT_FST_CNT <> ('1','2','19','20'),Avg_FIRST_CONTACT_WK_DAYS)), PROGRAM, DIVISION, REGION))

[m_woolf]

I'm pretty sure this statement doesn't work:

TEN_PERCENT_FST_CNT <> ('1','2','19','20')

[Anonymous]

Right. How can I fix this?

[Anonymous]

try 

TEN_PERCENT_FST_CNT-= ('1','2','19','20')

[Anonymous]

That's not it

[Anonymous]

avg(aggr(AVG({<ASSIGNED_STATUS = {'NEWLY ASSIGNED MEMBER' },TEN_PERCENT_FST_CNT -={'1','2','19','20'},Avg_FIRST_CONTACT_WK_DAYS)), PROGRAM, DIVISION, REGION)

or

avg(aggr(AVG({<ASSIGNED_STATUS = {'NEWLY ASSIGNED MEMBER' },TEN_PERCENT_FST_CNT ={'*}-{'1','2','19','20'},Avg_FIRST_CONTACT_WK_DAYS)), PROGRAM, DIVISION, REGION)

[vishsaggi · Accepted solution]

May be this?

=avg(aggr(AVG(if(ASSIGNED_STATUS = 'NEWLY ASSIGNED MEMBER' AND NOT Match(TEN_PERCENT_FST_CNT, '1','2','19','20'), Avg_FIRST_CONTACT_WK_DAYS)), PROGRAM, DIVISION, REGION))

Or Extending Wallo's expr: Need to close the set analysis.

avg(

        aggr(

                   AVG( {<

                                  ASSIGNED_STATUS = {'NEWLY ASSIGNED MEMBER' }, TEN_PERCENT_FST_CNT = {'*} - {'1','2','19','20'}

                             >}  Avg_FIRST_CONTACT_WK_DAYS

                           )

                         , PROGRAM, DIVISION, REGION

                 )

       )

[Anonymous]

Thanks for catching that.  I missed putting in the closing tags.  Sorry OP!