Flag duplicate on a straight table

[Geostidet]

Hi I am trying to create a field to flag duplicate  on  a straight table the field is a concatenation of 3 fields I do no have access to the back end (Script) to make change on the data model  so I am using this code it woks on just on field but on multiple field concatenate

 =if(count(total <ID&Tradedate&Tranno>ID&Tradedate&Tranno)> 1,'Duplicate','unique')

[Kushal_Chawda · Accepted solution]

@Geostidet  just a little change required

=if(count(total <ID,Tradedate,Tranno> ID&Tradedate&Tranno)> 1,'Duplicate','unique')

[Geostidet · Accepted solution]

@Kushal_Chawda thanks so much is it a way to flag the highlighted rows as duplicate regardless of the type  or dir  just taking in consideration ID&Tradedate&Tranno

[Kushal_Chawda]

@Geostidet  Yeah. It should.

[rwunderlich]

Since you are already grouping by the three fields, I think this could be simplified to count just a single field.

=if(count(total <ID,Tradedate,Tranno> ID)> 1,'Duplicate','unique')

-Rob