Hi Chad, If I got you right then your problem is that the concatenated string is empty if one of the attributes is empty (even though I'd rather expect || or + instead of & operator). In this case you can use the function coalesce to solve this. E.g. instead of the first attribute you need to use COALESCE (
[Inspection].[CEPO Special Inspection1].[CEPO Special Inspection1 Code] , '' ) and same for the other attributes.
To only add the needed ', ' you could try something like this (untested):
SUBSTRING (
COALESCE ( ', ' + [Inspection].[CEPO Special Inspection1].[CEPO Special Inspection1 Code] , '' ) +
COALESCE ( ', ' + [Inspection].[CEPO Special Inspection2].[CEPO Special Inspection2 Code] , '' ) +
COALESCE ( ', ' + [Inspection].[CEPO Special Inspection3].[CEPO Special Inspection3 Code] , '' ) +
COALESCE ( ', ' + [Inspection].[CEPO Special Inspection4].[CEPO Special Inspection4 Code] , '' )
, 3 )------------------------------
Philipp Hornung
------------------------------
#CognosAnalyticswithWatson