Suppress when value is null in expression

[bsbernabe]

Hello There,

How to suppress null using expression?

sample data

ID	SERIAL NUMBER	QUANTITY
544258	G600XYZ	-12
622120	-	-1

Output

ID	SERIAL NUMBER	QUANTITY
544258	G600XYZ	-12

Best Regards,

Bing

[sunny_talwar]

Which object is this? Straight table or pivot table?

[buzzy996]

try this

[Anil_Babu_Samineni]

You can do this as expression?

Sum({<[SERIAL NUMBER] = {"=Len([SERIAL NUMBER])>0"}>} QUANTITY)