GETCASEX

Returns the numeric value of the sex of a specified beneficiary, as follows:

  • 0: Unknown/None
  • 1: Male
  • 2: Female
Formula Syntax

GETCASEX(Index)

Index: enter 0 here to get the sex of the beneficiary that was chosen when running the calculation or export. Otherwise, enter an index of 1-5 to get the corresponding gender of the specified beneficiary.

Examples

GETCASEX(2) returns sex of the second beneficiary stored in the person's record

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com