Ignore selection with Aggr

[vvvvvvizard]

How do add ignore selection field "Reconsiler" to this expression

Count( Aggr( nodistinct
if([Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date]>0,[Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date])
,[When Reviewer Attested]) )
+
Count({<AccountState={'Pending Reviewer'}>} AccNumber)

[nisha_rai]

if you want to ignore the selection, use the below condition

Count({<AccountState={'Pending Reviewer'},Reconsiler=>} AccNumber)

it will ignore the Reconsiler field selection in count of Account Number

[vvvvvvizard]

And to ignore the selection in the top expression? 

[kavita25]

Try as below:

Count(Only({<Reconsiler>}  Aggr( nodistinct
if(only({<Reconsiler>}[Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date])>0,[Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date])
,[When Reviewer Attested]) )
+
Count({<AccountState={'Pending Reviewer'},Reconsiler=>} AccNumber)

Regards,

Kavita

[sunny_talwar · Accepted solution]

May be this

Count({<Reconsiler>} Aggr(NODISTINCT
    Only({<Reconsiler>} RangeMax([Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date], 0))
, [When Reviewer Attested]))

+

Count({<AccountState = {'Pending Reviewer'}, Reconsiler>} AccNumber)