Set Analysis - specific value

[#1]

Hello all,

In the list box page_storytellers_by_city_sub_name (image below) i want to create expression of all city from Noord-Holland.

my current expression is   =sum({$<page_storytellers_by_city_sub_name= {"Noord-Holland"}>}page_storytellers_by_city_value)

when i use this expression in the text object the value returns into 0. Which expression should i use?

Thank u so much!

Greets,

Rega

[sunny_talwar · Accepted solution]

What about this:

=Sum({$<page_storytellers_by_city_sub_name= {"*Noord-Holland*"}>}page_storytellers_by_city_value)

[#3]

Hey Sunny T,

And how about a expression to get result all city exclude "*Netherlands*"?

Thanks

[trdandamudi]

May be like below:

=Sum({$-1 <page_storytellers_by_city_sub_name= {"*Netherlands*"}>}page_storytellers_by_city_value)

[sunny_talwar]

May be this:

=Sum({$<page_storytellers_by_city_sub_name -= {"*Netherlands*"}>}page_storytellers_by_city_value)

Note a small negative sign before the equal sign