Please Help - Counting the number of Iterations, in Order.

[ben_skerrett]

I am hoping someone can please help with the below requirement.

The life-cycle of a document has multiple versions, with varying Revision Letters (also can be numeric or alpha-numeric).

- In the example below, the first two VERSIONS are REVISON 'A'. This is the first revision letter (based on created date) so i would like them to be a 1.

- The Third VERSION is REVISION B, so I would like this to be a 2

- The forth VERSION is an A, so I would like it to be a 1

- and the 5th VERSION is a B so i would like it to be a 2.

 

 Thanks in advance

Ben

[Or]

Perhaps it's an issue of the example being too simplistic, but it seems like in this case it would be solved by using:

Ord(Revision)-64

[ben_skerrett]

Thanks Or for the Prompt response but unfortunately it will not work. Our customer specifies the revision sequence, so we could have various sequences i.e.

• A,B,C...
• 0,1,2...
• AA,AB,AC...
• 00,01,01...etc.

Thanks 

Ben

[Mayur_Nilangekar9]

Hi All,

We can achieve desired out put by

Left Join (Main_Table)

Load Distinct

Document#&Revision As PrimaryKey

Autonumber(Document#&Revision, Document#) As DesiredOutPut

Resident Main_Table;