Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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
)
)
I'm pretty sure this statement doesn't work:
TEN_PERCENT_FST_CNT <> ('1','2','19','20')
Right. How can I fix this?
try
TEN_PERCENT_FST_CNT-= ('1','2','19','20')
That's not it
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)
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
)
)
Thanks for catching that. I missed putting in the closing tags. Sorry OP!