Forum Discussion

AlexG3726's avatar
AlexG3726
Frequent Visitor
4 years ago
Solved

Grouping Items based on SWITCH?

Hello, I have a bunch of vairous loans that I would like to group based on text each loan contains, and then display  data based on those groups. When I use the formula below does not display the co...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I think you want CONTAINSSTRING instead. 

     

    Loan Program =
SWITCH (
    TRUE (),
    CONTAINSSTRING ( loan[loanname],        "2nd"    ), "Second/HELOC",
    CONTAINSSTRING ( loan[loanname],        "High"   ), "High Balance",
    CONTAINSSTRING ( loan[loanname],        "Jumbo"  ), "Jumbo",
    CONTAINSSTRING ( loan[loanname],        "Non-QM" ), "Non-QM",
    CONTAINSSTRING ( loan[loanname],        "HECM"   ), "Reverse",
    CONTAINSSTRING ( loan[loanname],        "USDA"   ), "USDA",
    CONTAINSSTRING ( loan[loanname],        "CONV"   ), "CONV",
    CONTAINSSTRING ( loan[loanname],        "VA"     ), "VA",
    CONTAINSSTRING ( loan[loanprogramname], "FHA"    ), "FHA",
    "NA"
)
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

I think you want CONTAINSSTRING instead. 

 

Loan Program =
SWITCH (
    TRUE (),
    CONTAINSSTRING ( loan[loanname],        "2nd"    ), "Second/HELOC",
    CONTAINSSTRING ( loan[loanname],        "High"   ), "High Balance",
    CONTAINSSTRING ( loan[loanname],        "Jumbo"  ), "Jumbo",
    CONTAINSSTRING ( loan[loanname],        "Non-QM" ), "Non-QM",
    CONTAINSSTRING ( loan[loanname],        "HECM"   ), "Reverse",
    CONTAINSSTRING ( loan[loanname],        "USDA"   ), "USDA",
    CONTAINSSTRING ( loan[loanname],        "CONV"   ), "CONV",
    CONTAINSSTRING ( loan[loanname],        "VA"     ), "VA",
    CONTAINSSTRING ( loan[loanprogramname], "FHA"    ), "FHA",
    "NA"
)
AlexG3726's avatar
AlexG3726
Frequent Visitor
4 years ago

Wonderful, Thanks!