Hello,
I have a table field with line items of delivery notes. Somehow I need to be able to remove lines from the table field where the "Quantity" (one of the columns, decimal, 4 decimal digits) contains "0.0000"
The table field looks somewhat like this at the beginning:
Sys Line No
|
Quote Line No
|
Product Code
|
Quantity
|
1
|
3
|
Prod123
|
12.0000
|
2
|
2
|
Prod234
|
0.0000
|
3
|
1
|
Prod345
|
10.0000
|
After removing the unwanted line I would expect this:
Sys Line No
|
Quote Line No
|
Product Code
|
Quantity
|
1
|
3
|
Prod123
|
12.0000
|
2
|
1
|
Prod345
|
10.0000
|
Any help is greatly appreciated!
Thanks!
Jan