Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI there can anybody help me merging these two expressions :
1> =if(count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,
-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])>count({$<[PGA]={'A'},'arrow up icon','arrow down icon')
2> if(count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,
-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])=count({$<[PGA]={'A'})>} [Recipient Identifier]),
'resize horizontal icon')
Maybe like
if(
count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,
-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])=count({$<[PGA]={'A'}>} [Recipient Identifier]),'resize horizontal icon',
if(count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,
-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])>count({$<[PGA]={'A'}>} [Recipient Identifier]),'arrow up icon','arrow down icon')
)
Not sure if your syntax of your advanced search is correct, though. Does each expression work on its own?
Maybe like
if(
count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,
-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])=count({$<[PGA]={'A'}>} [Recipient Identifier]),'resize horizontal icon',
if(count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,
-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])>count({$<[PGA]={'A'}>} [Recipient Identifier]),'arrow up icon','arrow down icon')
)
Not sure if your syntax of your advanced search is correct, though. Does each expression work on its own?
Thank Sweul!!!
yes my Advanced search was working fine .