Expression problem

[woshua5550]

Dear All

I have a table looks like this :

I can get cities whose value is all 0 by using "=Concat(DISTINCT{<Value={0}>} City ,',')",it will return "Chongqing,Nanjing"

but how to get cities whose value is all NULL ? , I need a expression, in my case , should return  "Shanghai,Heibei"

thanks

[sunny_talwar]

May be this

=Concat(DISTINCT{<City = {"=Sum(Value) = 0"}>} City ,',')

[antoniotiman · Accepted solution]

Try

=Concat({<City={"=Sum(Value)=0"}>-<Value={0}>} DISTINCT City,';')

Regards,

Antonio

[sunny_talwar]

Or just this to get two Cities

=Concat(DISTINCT{<City = {"=Sum(Value) = 0 and Value <> 0"}>} City ,',')

[woshua5550]

Awesome 

[woshua5550]

Both very nice , thx a lot