Not equal symbol in set analysis

[raju_salmon]

Hi,

Not equal symbol work in SET ANALYSIS?

Expression error is showing for me.

Count({$<Sales<>{0}>}Sales)  - Not working

Count({$<Sales={0}>}Sales)  - working

I want to exclude 0 sales. How can we use not equal in set analysis?

Thanks.

Raju.

[Gysbert_Wassenaar · Accepted solution]

Try: Count({$<Sales<>{'>0<0'}>}Sales)

But since negative Sales are not possible (afaik) this can be used: Count({$<Sales={'>0'}>}Sales)

This often works too: Count({$<Sales-={0}>}Sales)