Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Which object is this? Straight table or pivot table?
try this
You can do this as expression?
Sum({<[SERIAL NUMBER] = {"=Len([SERIAL NUMBER])>0"}>} QUANTITY)