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.


      1 Self

      2 Self / Child

      3 Self / Spouse / Child

      4 Self / Spouse / Child / Child



      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