9 Replies Latest reply on Aug 14, 2019 8:39 AM by Will Dickinson

    Counting and Grouping Dimension Text  to Create Grouping and Family Makeup / Composition / Head of Household

    Will Dickinson

      Trying to use a calculated field to create "Family Composition" for sorting what type of family an individual belongs too.

      Example:

      1 Self

      2 Self / Child

      3 Self / Spouse / Child

      4 Self / Spouse / Child / Child

      etc....

       

      I was able to calculate the family size but not break out the "family composition" groupings ... please advise

       

       

      This as far I got:

       

      The count of members wasn't correct and not sure this the right approach