3 Replies Latest reply on Oct 15, 2015 8:58 AM by dyb

    A mistake in Starter Solution?

    dyb

      Is this calculation wrong or am i just missing something?

       

      Upper     (

              Case        (

                      not IsEmpty ( Last ) ;

                      Left ( Last ; 1 ) ;

                      not IsEmpty ( First ) ;

                      Left ( First ; 1 ) ;

                      not IsEmpty ( Company ) ;

                      Left ( Company ; 1 ) ;

                      ""

                      )

              )

       

       

      "Contacts::Initial", Starter Solution: "Projects", FMP14

       

      Instead of getting 2 or 3 letter initials it only gets 1 letter.

        • 1. Re: A mistake in Starter Solution?
          StephenWonfor

          If 2 or 3 initials expected it looks as though you'd need 3 Case statements concatenated.  That calc is a 1 only.

           

          Case( not IsEmpty ( Last ) ; Left ( Last ; 1 )  & Case( not IsEmpty ( First ) ; Left ( First ; 1 )  & Case( not IsEmpty ( Company ) ; Left ( Company ; 1 )

          1 of 1 people found this helpful
          • 2. Re: A mistake in Starter Solution?
            alquimby

            The calculation is correct. The purpose is to return one initial so that the person can be grouped according to the data available. If there is a Last Name available (the first choice in the Case statement), the first letter of the last name is returned. If there is a First Name with no Last Name (the second choice in the Case statement), then the first letter of the First Name is returned. Finally, if there is only a Company name, the first letter of it is returned. A Case statement stops after the first "true" is returned.

             

            Al Quimby

            • 3. Re: A mistake in Starter Solution?
              flybynight

              The calc is correct. To build on what Allen said…

              The key thing to remember is that it is named "Initial" - not "Initials" so it is meant to only return 1 letter. It is used in the list views to group the records by letter in an alpha listing. That field is used as the sub-summary break field.

              1 of 1 people found this helpful