anyone who knows the solution of removing duplicate saved search result data ? I got incorrect result data.
criteria and results:
j
Jesper M
08/09/2022, 12:06 PM
Hi! Try adding this numeric formula in your criteria and set it equal 0
MOD({linesequencenumber},3)
g
gellete99
08/09/2022, 12:11 PM
not worked. result is empty.
c
Corey Schwoebel
08/09/2022, 1:13 PM
Add COGS Line = False/No to your criteria
r
RJMNS
08/09/2022, 4:19 PM
Your ID field is unique between the two lines so those aren't technically dupes. You'd need to remove that or work on a way to make the amount zero for one of them or something.