Hi All,

I just want to know if there is a possible

Field A Calculated Field B

2 20

2

It means that the first record show calculated result , the second duplicate or many duplicate does now show anything.

I am trying to use count but does not work.

Anh Tran

Hi Anh,

Case(Status(CurrentRecordID) = 1 , "EnterYourCalculationHere")

This may do what you want.

Regards,

Ernst.

Min(selfid::serial) = serial will produce a 1 when the record is the first in the file with 'selfid' (whatever field should be unique) and a 0 for any duplicates.

I have tried the Ernst's solution, but it does not work. And the idea of Queue, I got no clue ... Queue , could you clear a little bit your idea?

Thanks

Anh Tran

Sorry Anh,

It should be:

Case(Status(CurrentRecordNumber) = 1 , "EnterYourCalculationHere")

So 'Number' in stead of 'ID'

Regards,

Ernst.

Say serial is a unique id for every record, field is the determing factor for duplicate records and self is a self-relationship based on this field. Then Min(self::serial) will result in the lowest serial for all records in the file where field is the same as that of the current record. Compare that to the serial of the current record: Min(self::serial) = serial. If the serials match, you'll get a 1; if not, then you'll get a zero. You can then either use this result or incorporate it into your Case() if you want to display more than just 1 or zero.

Does that help clarify?

I did try the SELF relational to find the duplicated record, but you cannot make the "field" to be indexed because it is relational calculation field. It is any way to make the field to be indexed without scripting.??

Any idea?

I wonder why exactly you would want to index it. It doesn't need to be stored to be used for the left-hand side of a relationship. But, if you have a case where you need it for the right-hand side, then I would look into Ray's fabulous technique found here.

Thanks Alot Queue

It works fine

Anh Tran