Flagging peek value

[arpitkharkia]

Hi all,

I am using Peek() function to flag my peek values. So according to my logic if a values occurs second time in a particular field i flag it as 1. So if A occurs twice the second record is flagged 1, 2 for B, 3 for C and so on.

I need to flag the previous record with the same flag. So the first record of where A occurs should be 1,B will be 2 and so.

What i have

Field1	Flag
A
A	1
B
B	2

What i need

Field1	Flag
A	1
A	1
B	2
B	2

Thanks!

[sunny_talwar]

Not sure I understand completely, but may you need AutoNumber()

AutoNumber(Field1)

[isingh30]

Your requirement is not clear to me. What exactly you need?

Thank you!