Count in set analysis

[paulwalker]

Hi Community,

can you please correct me below expression, not giving any value..

same expression have written script level working fine, but in set analysis not giving any value

=AVG(AGGR(AVG({$<OrgCode= {"=Count(DISTINCT OrgCode)>2"}>}BASE_SALARY), SURVEY, MUPC_CODE, Industry))

Thanks in Advance

[Lisa_P]

from what I can see, the issue is that the Count(distinct OrgCode) is always 1, so this condition is never met, as well it will not give any OrgCodes either as they are all strings, not numbers.