Rank Aggr If condition not displaying any values

[Sai78]

Im trying to display the values in list box based on count of values ...Top 20 or ALL  identifers based on conditions(and  ,or conditions).. can you please help if I'm doing any mistake here ..Thanks in advance

=IF(Att=1,aggr(if(rank(if(
( Status='Missing'and DateType='CaseCreatedDate' )
OR
( [Type] = '$(vCy)' and RelatedEnd >=$(vToday)and RelatedEnd <=$(v30Days))
OR
([Type] = 'PP' and Related2End >=$(vToday)and Related2End <=$(v30Days) )
OR ([approvals] = '0') and [Type] = '$(vCy)' , [Identifier]))<=20,[Identifier]), [Identifier]) 

,IF(Att<>1,IF( if(
( Status='Missing'and DateType='CaseCreatedDate' )
OR
( [Type] = '$(vCy)' and RelatedEnd >=$(vToday)and RelatedEnd <=$(v30Days))
OR
([Type] = 'PP' and Related2End >=$(vToday)and Related2End <=$(v30Days) )
OR ([approvals] = '0') and [Type] = '$(vCy)' , [Patient Identifier]) ))

[sunny_talwar · Accepted solution]

@Sai78  How about this?

=IF(vPtNdAtt=1,aggr(if(rank(if(
  ( Status='Missing'and DateType='CaseCreatedDate' ) 
OR
  ( [Type] = 'CC'and [RelatedEnd ]  >=$(vToday)and [RelatedEnd ] <=$(v30Days))
OR
  ([Type] = 'PP'   and [Related2End ]  >=$(vToday)and [Related2End ] <=$(v30Days) )
OR ([approvals] = '0') and [Type] = 'CC' ,   [Created_Date]))<=20,[Identifier]),  [Identifier]) 


,IF(vPtNdAtt<>1,IF(    
  ( Status='Missing' and DateType='CaseCreatedDate' ) 
OR
  ( [Type] = 'CC'and [RelatedEnd ] >=$(vToday)and [RelatedEnd ]<=$(v30Days))
OR
  ([Type] = 'PAP'   and  [Related2End ] >=$(vToday)and  [Related2End ]<=$(v30Days) )
OR ([approvals] = '0' and [Type] = 'CC') ,   [Identifier])  ))