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

# A mistake in Starter Solution?

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?

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?

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?

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