Family Historian User Group

=Relationship(FileRoot(),%INDI%,TEXT,1) works fine until the sex of the person is unknown.

Have a stillborn child born 1929 that no one knows if boy or girl. I cleared the 'Sex:' box and when building a Diagram or Report a male relationship is shown. I expect =Relationship(FileRoot(),%INDI%,TEXT,1) is defaulting to Male as that is the first option in the 'Sex:' menu.

Is there anyway of returning both the Male / Female relationship or no output when the sex is unknown ?

ID:7016

I suppose 'child', 'grandchild', 'great grandchild', etc., would work for direct descendants of the root individual, but I'm not aware of a gender-neutral term for niece/nephew.

The following would produce no output if the Sex is undefined.

=TextIf( IsEmpty(%INDI.SEX%), ,Relationship(FileRoot(),%INDI%,TEXT,1) )

Thanks Mike. Spot on as usual [smile]