problem in not like syntax in count function

[saivina2920]

I'm trying to get count of values from specific column.

i'm able to get count if i use like condition. example is below.

=count(distinct [ColumnA] like '%TOTAL PROFIT%')

Suppose if want to get not like '%TOTAL PROFIT%',  then

what would be the syntax or different logic would be use..?

[Anil_Babu_Samineni · Accepted solution]

Not sure, How your expression is working? May be try this way?

count(distinct {<[ColumnA] -= {'*TOTAL PROFIT*'}>} [ColumnA])

[saivina2920]

Thanks for your reply.
I tried the below.
count(distinct {<[ColumnA] -= {'*TOTAL PROFIT*'}>} [ColumnA])
but both matching and non-matching showing the same count. i have different records.
How it is possible.

[saivina2920]

any update...

[saivina2920]

Great...