Sum({< [Policy Revision Group] = {$(=Concat(Chr(39) & GetFieldSelections([PRG Filter]) & Chr(39), ‘,’))}, [Product Code] = {$(=Concat(Chr(39) & GetFieldSelections([PC Filter]) & Chr(39), ‘,’))}>} [Renewed Paid])
ou on peut travailler avec une variable
LET vPRGFilter = Concat(GetFieldSelections([PRG Filter]), ‘,’);
=if(GetFieldSelections(Period)=’3 Mths’, If( [Start Date] >= today(2) and [Start Date] <= AddMonths(today(2),3), [Start Date]))
or
=if(GetFieldSelections(Period)=’3 Mths’, Aggr(Only({<[Start Date] = {« $(=’>=’ & Date(today(2), ‘D/M/YYYY’) &'<=’ & Date(AddMonths(today(2),3), ‘D/M/YYYY’)) »} >} [Start Date]), [Start Date]) )
