Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
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
And to ignore the selection in the top expression?
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
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)