2 Replies Latest reply on Oct 26, 2012 10:08 AM by CraigFiore

    MAX with text

    CraigFiore

      Title

      MAX with text

      Post

           Hello everyone, 

           I was wondering if anyone know how to get MAX with letters. Then caculate the next highest letter in the alphabet for a field.

           Here is what I am doing incase somone has a better idea:

           I have created and ouline type format with Sections. The Sections are labeled A, B, C and so on. I am trying to created a script that will find the highest letter then add the next letter for a new section. Is this possible?

           Thank you,

           C

        • 1. Re: MAX with text
          philmodjunk

               Define a calculation field as:

               Code ( LetterField )

               Then a summary field, sMaxLetterCode, can defined as the maximum of this calculation field.

               And this expression will compute the next letter in the series:

               Char ( sMaxLetterCode + 1 )

               This will only work if you have a found set of all records. A similar method, however can produce the same results via a self join relationship and then the state of the current found set is not a factor.

          • 2. Re: MAX with text
            CraigFiore

                 Thank you. It works perfect.