Family Historian User Group

Am trying to create a last married name for females only in a Result Set column in various queries.

=TextIf((%INDI.SEX%=Female)(Exists(%INDI.FAMS[last]>HUSB>%),%INDI.FAMS[last]>HUSB>NAME:SURNAME%,%INDI.NAME:SURNAME%)

The above expression is not valid. How do I correct. I want result for only females exclusive of males.

You need to turn the condition parameter into a valid boolean expression:

=TextIf( IsTrue( ( %INDI.SEX% = "Female" ) and Exists( %INDI.FAMS[last]>HUSB>% ) ), %INDI.FAMS[last]>HUSB>NAME:SURNAME% ,%INDI.NAME:SURNAME% )

When I insert expression you corrected for me, males are also listed with surname.

Yes, well that is what the expression does.
If the person is female and has a husband, it shows the last husband's surname, otherwise (for males and unmaried women) it shows the person's surname.
You need nested TextIf if you want to exclude males altogether.

I am having trouble to nest expression to achieve desired result. Help/hint please.

The nesting approach needs to replace %INDI.NAME:SURNAME% with a TextIf(...) function such as:
TextIf( %INDI.SEX% = "Female", %INDI.NAME:SURNAME%, "" )

Tip: Ensure the ( parentheses ) are correctly nested by counting them in pairs.

However, in this case, there is another solution using the =Sex(...) and =CombineText(...) functions:
=Sex( %INDI%, "", CombineText( "", %INDI.FAMS[last]>HUSB>NAME:SURNAME%, "", %INDI.NAME:SURNAME% ), "")
i.e.
=Sex( %INDI%, <male name blank>, <female name expression>, <unknown sex blank> )

<female name expression> = CombineText( "", %INDI.FAMS[last]>HUSB>NAME:SURNAME%, "", %INDI.NAME:SURNAME% )
i.e.
CombineText( <blank prefix>, <last husband surname>, <blank suffix>, <maiden name when no husband> )

Great help. Thanks