Forum Discussion
Solved
Identify duplicate rows
Hello togehter, Table1 Cost Center GL Account DocNo Amount 2525001 5455506 DE452K 450.11 2525001 5455506 DE477B 450.11 2525040 5456000 DE333C 83.45 I want to ident...
But, you can convert a text inside in measure to a number using the VALUE function
Hi Stelles3000
I identify with duplicate but the doc number is different in all the codes if you see I'm only comparing gl account, cost center and amount. The result is giving the same has you present on the post two lines and different doc numbers.
Isn't that the result you want?
Yes, but the DocNo must be different, so it should not equal. There are examples with identical values, I dont want these.