Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
(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)
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)
(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)
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)