Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Enclose string values in single quotes. Use -= for not.
sum({<entity={'asia'},category -= {'public'}>}[GBP value])
Enclose string values in single quotes. Use -= for not.
sum({<entity={'asia'},category -= {'public'}>}[GBP value])