Exclude '*' value using exclude(e) in set analysis.

[#1]

Hi all,

I want the result exclude '*'  using e in set analysis

for example.  "=Count({$<ADVANCEID=e({1<ADVANCEID={'*'}>})>}ADVANCEID)". But this is not working.

Pleas help me out guys...

[sunny_talwar]

Try this:

=Count({$<ADVANCEID = ADVANCEID = {" =ADVANCED <>'*'  "}>})>}ADVANCEID)

Also attaching a small sample where I tried to test it out