ask.. what is syntax of "not equal to" in expression?

[#1]

hello, newbie need help,

thank you before..

what is syntax of "not equal to" in expression??

example,

count({<cancel = {'0'}>} sales) <---- that is equal to 0

now i want to set the condition that cancel <> 0

i use,

count({<cancel <> {'0'}>} sales) <---- it doesn't work..

help me plis,

thank you so much

regards !

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Use

count({<cancel -= {'0'}>} sales)

Meaning "all values for field cancel except for '0'".

Hope that helps.

[#3]

thank you miquel

best regards !