unable to use <> in formula

[Anonymous]

Hi,

i am using the following formula but would like to add "ProdType<>'200021'".  I don't seem to be able to use "<>".  what should i be using?

ok:-

=Count(DISTINCT {<IsMember={'Yes'},[ProdTypeCode]={'Membership'}>}[AccountNo]&[AccountName]&[ProductClassificationSummary])-1

when i add "ProdType<>{'200021'}>" the formula doesn't work. 

=Count(DISTINCT {<IsMember={'Yes'},[ProdTypeCode]={'Membership'},ProdType<>{'200021'}>}[AccountNo]&[AccountName]&[ProductClassificationSummary])-1
 

Cheers,

Lc

[tamilarasu]

Hi,

Try like below,

=Count(DISTINCT {<IsMember={'Yes'},[ProdTypeCode]={'Membership'},ProdType= {'*'}-{'200021'}>}[AccountNo]&[AccountName]&[ProductClassificationSummary])-1

[engishfaque]

Dear Laura,

Please share your sample data.

Kind regards,

Ishfaque Ahmed