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
Yes, but the DocNo must be different, so it should not equal. There are examples with identical values, I dont want these.
Sorry for the additional questions, so when you have a docnum equal you don't want to count the repetead ones?
Can you send an example of data where you have that type of information (duplicated doc numbers) and expected result? On the first example you only had 3 lines so it's diffficult to duplicate your data and get accurate results.
Thank you in advance.