anyone who knows the solution of removing duplicat...
# general
g
anyone who knows the solution of removing duplicate saved search result data ? I got incorrect result data. criteria and results:
j
Hi! Try adding this numeric formula in your criteria and set it equal 0 MOD({linesequencenumber},3)
g
not worked. result is empty.
c
Add COGS Line = False/No to your criteria
r
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.