Add filter from expression

[ttal7878]

Hi,

Is it possible to add this expression into list box,

so the user will have the option to select 'Yes'/'No' filter?

=if(sum({<PendingsPayments.unique_num= P({<cctranzresponse={'000'},Age={0},Calendar_TRX.Calendar_Date,Calendar_TRX.Day,Calendar_TRX.Month,Calendar_TRX.Year>}PendingsPayments.unique_num)>}PendingsPayments.unique_num)>1,'No',

if(sum({<PendingsPayments.unique_num= P({<cctranzresponse-={'000'},Age={0},Calendar_TRX.Calendar_Date,Calendar_TRX.Day,Calendar_TRX.Month,Calendar_TRX.Year>}PendingsPayments.unique_num)>}PendingsPayments.unique_num)>1,'yes'))

[Chanty4u · Accepted solution]

try to use aggr,

=aggr(if(sum({<PendingsPayments.unique_num= P({<cctranzresponse={'000'},Age={0},Calendar_TRX.Calendar_Date,Calendar_TRX.Day,Calendar_TRX.Month,Calendar_TRX.Year>}PendingsPayments.unique_num)>}PendingsPayments.unique_num)>1,'No',

if(sum({<PendingsPayments.unique_num= P({<cctranzresponse-={'000'},Age={0},Calendar_TRX.Calendar_Date,Calendar_TRX.Day,Calendar_TRX.Month,Calendar_TRX.Year>}PendingsPayments.unique_num)>}PendingsPayments.unique_num)>1,'yes')),Dimension)

[tresesco]

Yes. Only thing is, you have to use an aggr() like:

=Aggr( If(Sum(.....)), Dim1, Dim2,..)

[ttal7878]

Thank you!