Set Expression for capturing some data

[nevilledhamsiri]

Hi,

I have a table like below

Code     values

77480     500

77170     1000

45150     450

78110    

77450

75150

Please write a set expression to get the list of codes which carries no values.

Thanks

Neville

[sunny_talwar]

Can you reload the app and save back... there is no data in the attached app

[nevilledhamsiri]

Thank Sunny for your assistant one point after the other. You are alright. The consistently what you proposed to be made produced results in the end. I have not applied the "value" in block letters as it is loaded. Correct now. Thanks a lot

CODE	SUM(VALUE)	Sum({<CODE={"=Sum(VALUE)=0"}>}CODE)
45150	2000	0
75170	0	75170
77110	500	0
77150	1500	0
78100	200	0
78145	0	78145