Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What about this:
=Sum({$<page_storytellers_by_city_sub_name= {"*Noord-Holland*"}>}page_storytellers_by_city_value)
What about this:
=Sum({$<page_storytellers_by_city_sub_name= {"*Noord-Holland*"}>}page_storytellers_by_city_value)
Hey Sunny T,
And how about a expression to get result all city exclude "*Netherlands*"?
Thanks
May be like below:
=Sum({$-1 <page_storytellers_by_city_sub_name= {"*Netherlands*"}>}page_storytellers_by_city_value)
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