Find empty related records - COUNT or PATTERNCOUNT

[Ugo DI LUCA]

I'm looking for a way to find related records from g_Name::Name where the Last Name is empty.

I've tried Count(selfjoinon_gName_tName::t_LastName) = " " or PATTERNCOUNT(selfjoinon_gName_tName::t_LastName; " " ).

Cannot have the number of empty last names for the same first name.

[Ugo DI LUCA]

I found a workaround but I'm sure there is a cleaner solution.

c_matchempty = Case(isempty("lastname","Empty","")

global g_Emptylastname field = text ----> "Empty"

2 concanated

c_t_concanated = Name&"-"&c_matchempty

c_g_concanated = g_Name&"-"&g_Emptylastname

Relationship c_g_concanated::c_g_concanated

checkemptylastname = Count (selfjoin::c_t_concanated)