Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Thanks! it works!