Forum Discussion
MarkShnier__You
Qrew Champion
Try this one. It tests OK for me.
var text MultiA = ToText([Secondary Risk Categories]);
var text MultiB = ToText([Reporting - Secondary Risk Category]);
var text BOne = Trim(Part(ToText([Reporting - Secondary Risk Category]),1,";"));
var text BTwo = Trim(Part(ToText([Reporting - Secondary Risk Category]),2,";"));
var text BThree = Trim(Part(ToText([Reporting - Secondary Risk Category]),3,";"));
var text BFour = Trim(Part(ToText([Reporting - Secondary Risk Category]),4,";"));
var text BFive = Trim(Part(ToText([Reporting - Secondary Risk Category]),5,";"));
var text BSix = Trim(Part(ToText([Reporting - Secondary Risk Category]),6,";"));
var text BSeven = Trim(Part(ToText([Reporting - Secondary Risk Category]),7,";"));
var text BEight = Trim(Part(ToText([Reporting - Secondary Risk Category]),8,";"));
var text BNine = Trim(Part(ToText([Reporting - Secondary Risk Category]),9,";"));
var text BTen = Trim(Part(ToText([Reporting - Secondary Risk Category]),10,";"));
var text BEleven = Trim(Part(ToText([Reporting - Secondary Risk Category]),11,";"));
var text BTwelve = Trim(Part(ToText([Reporting - Secondary Risk Category]),12,";"));
var text BThirteen = Trim(Part(ToText([Reporting - Secondary Risk Category]),13,";"));
If(
$BOne <>"" and Contains($MultiA, $BOne), "Yes",
$BTwo <>"" and Contains($MultiA, $BTwo), "Yes",
$BThree <>"" and Contains($MultiA, $BThree), "Yes",
$BFour <>"" and Contains($MultiA, $BFour), "Yes",
$BFive <>"" and Contains($MultiA, $BFive), "Yes",
$BSix <>"" and Contains($MultiA, $BSix), "Yes",
$BSeven <>"" and Contains($MultiA, $BSeven), "Yes",
$BEight <>"" and Contains($MultiA, $BEight), "Yes",
$BNine <>"" and Contains($MultiA, $BNine), "Yes",
$BTen <>"" and Contains($MultiA, $BTen), "Yes",
$BEleven <>"" and Contains($MultiA, $BEleven), "Yes",
$BTwelve <>"" and Contains($MultiA, $BTwelve), "Yes",
$BThirteen <>"" and Contains($MultiA, $BThirteen), "Yes", "No")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text MultiA = ToText([Secondary Risk Categories]);
var text MultiB = ToText([Reporting - Secondary Risk Category]);
var text BOne = Trim(Part(ToText([Reporting - Secondary Risk Category]),1,";"));
var text BTwo = Trim(Part(ToText([Reporting - Secondary Risk Category]),2,";"));
var text BThree = Trim(Part(ToText([Reporting - Secondary Risk Category]),3,";"));
var text BFour = Trim(Part(ToText([Reporting - Secondary Risk Category]),4,";"));
var text BFive = Trim(Part(ToText([Reporting - Secondary Risk Category]),5,";"));
var text BSix = Trim(Part(ToText([Reporting - Secondary Risk Category]),6,";"));
var text BSeven = Trim(Part(ToText([Reporting - Secondary Risk Category]),7,";"));
var text BEight = Trim(Part(ToText([Reporting - Secondary Risk Category]),8,";"));
var text BNine = Trim(Part(ToText([Reporting - Secondary Risk Category]),9,";"));
var text BTen = Trim(Part(ToText([Reporting - Secondary Risk Category]),10,";"));
var text BEleven = Trim(Part(ToText([Reporting - Secondary Risk Category]),11,";"));
var text BTwelve = Trim(Part(ToText([Reporting - Secondary Risk Category]),12,";"));
var text BThirteen = Trim(Part(ToText([Reporting - Secondary Risk Category]),13,";"));
If(
$BOne <>"" and Contains($MultiA, $BOne), "Yes",
$BTwo <>"" and Contains($MultiA, $BTwo), "Yes",
$BThree <>"" and Contains($MultiA, $BThree), "Yes",
$BFour <>"" and Contains($MultiA, $BFour), "Yes",
$BFive <>"" and Contains($MultiA, $BFive), "Yes",
$BSix <>"" and Contains($MultiA, $BSix), "Yes",
$BSeven <>"" and Contains($MultiA, $BSeven), "Yes",
$BEight <>"" and Contains($MultiA, $BEight), "Yes",
$BNine <>"" and Contains($MultiA, $BNine), "Yes",
$BTen <>"" and Contains($MultiA, $BTen), "Yes",
$BEleven <>"" and Contains($MultiA, $BEleven), "Yes",
$BTwelve <>"" and Contains($MultiA, $BTwelve), "Yes",
$BThirteen <>"" and Contains($MultiA, $BThirteen), "Yes", "No")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
LukeFuruto
3 years agoQrew Trainee
Works like a charm! I'm so grateful. Thanks so much for all your help on this.