Expression help

[JoseGarcia]

Hi there, 
I need to exclude this two fields form expression below.
[Region_name] [Country name]

Not sure where to add the exclusion.

here is the expression: 

(count({<PeriodType={'Current'}, COD_num = {'<=$(vToday)'}>}counter_DFQ_DoneinMonth)-count({<Flag_Lookahead_accuracy= {'GR of Lookahead accuracy KO'}, COD_num = {'<=$(vToday)'}>}Flag_Lookahead_accuracy))
/
count({<PeriodType={'Current'}, COD_num = {'<=$(vToday)'}>}counter_DFQ_DoneinMonth)

thanks as always!

[anat · Accepted solution]

(count({<[Region_name] =,[Country name]=,PeriodType={'Current'}, COD_num = {'<=$(vToday)'}>}counter_DFQ_DoneinMonth)-count({<[Region_name] =,[Country name]=,Flag_Lookahead_accuracy= {'GR of Lookahead accuracy KO'}, COD_num = {'<=$(vToday)'}>}Flag_Lookahead_accuracy))
/
count({<[Region_name] =,[Country name]=,PeriodType={'Current'}, COD_num = {'<=$(vToday)'}>}counter_DFQ_DoneinMonth)

[LRuCelver · Accepted solution]

I've added a new set analysis to the front containing the two fields and the COD_num from all other analyses.

Try this:

{<COD_num = {'<=$(vToday)'}, [Region_name]=, [Country name]=>}
(
    Count({<PeriodType={'Current'}>} counter_DFQ_DoneinMonth)
  - Count({<Flag_Lookahead_accuracy= {'GR of Lookahead accuracy KO'}>} Flag_Lookahead_accuracy)
)
/
Count({<PeriodType={'Current'}>} counter_DFQ_DoneinMonth)