Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]) ))
@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]) ))