expression sum query

[#1]

hi

while we wirte teh below expression, can we write not equal to :

= sum({<entity={asia},category<>{public}>}[GBP value])

this is not working as in category i have values (public, private and open) but new categories will keep coming so how to sum all excluding Public Category

thanks

[Gysbert_Wassenaar · Accepted solution]

Enclose string values in single quotes. Use -= for not.

sum({<entity={'asia'},category -= {'public'}>}[GBP value])