Trying to do a simple formula combining the PR Employee last name with the suffix. Both fields are PII fields. When I run the report data formula only works if employee has a suffix so I had to place the last name field in the report and then cover it with the formula field to get all to print, but doing it that way messes up the excel export trying to achieve.

 Does anyone know if this is just the way it is or is there some trick to get this formula to print whether or not there is a suffix in there?

{PR_EmployeePIIWrk.LastName} & "," & {PR_EmployeePIIWrk.Suffix}