Cal di

[smilingjohn]

Hi Commu....

Thanks in Advan

[smilingjohn]

Hi community any help on my post ???

[Anil_Babu_Samineni]

May be remove the Pick(match()) around.. I meant like this

if(Aggr(Count(DISTINCT Product_Tower),Product_Tower)>0,
if(aggr(count(Distinct if([Sub-Capabilites]=Sub_Cap and WildMatch(LABEL,'*NoMode*')>0,JIRA_KEY_ID)),[Sub-Capabilites])>0,'R',
if(aggr(count(Distinct if([Sub-Capabilites]=Sub_Cap ,JIRA_KEY_ID)),[Sub-Capabilites])>0,'G',
if(aggr(count(Distinct if(WildMatch(LABEL,'*NoMode*')>0,JIRA_KEY_ID)),Capabilites)>0,'R',
if(aggr(count(Distinct JIRA_KEY_ID),Capabilites)>0,'G','B')))))