restricted condition in sum function

[#1]

Hi all,

I have a question regarding the use of condition in sum function. I have the expression as follows at the moment.

count( {<Country-={'Local'}, B= {1}, C -= {'text'}>}user)

However, the number always changed, when I selected some country. What I want is to deactivate the selection of country.

I know the use of 1 to be inserted to the expression like count( {1<Country-={'Local'}, B= {1}, C -= {'text'}>}user), but then no matter whether I select a additional field D. The number does not change as well.

Does anyone know how to solve this solution? Thank you

[sunny_talwar]

Reposition the negative sign from front of the = to back of the =

Count({<Country = -{'Local'}, B = {1}, C -= {'text'}>}user)

or try this

Count({<Country = e({<Country = {'Local'}>}), B = {1}, C -= {'text'}>}user)

[#3]

Thanks! it works!