Additive Multi Select issues with contains
I have a multi select field where the choices affect one or more of six other currency fields. The idea is that when a choice is made in the Multi Select that choice may add dollar amounts to one or ...
Forum Discussion
THIS ANSWER HAS BEEN UPDATED TO FIX A TYPO
Try this:
var Text string = " ; " & "ToText([Radius Fees]) & " ; " ;
If(Contains($string), " ; Cable Abort ; "), 0, 0) +
If(Contains($string), " ; Greater than 24 - No date ; "), 0, 0) +
If(Contains($string), " ; LEAD Abort ; "), 0, 0) +
If(Contains($string), " ; HANDS Abort ; "), 0, 0) +
If(Contains($string), " ; RADIUS Abort ; "), 100, 0) +
If(Contains($string), " ; Missing Cable - LMI ; "), 400, 0) +
If(Contains($string), " ; Missing Cable - Radius ; "), 0, 0) +
If(Contains($string), " ; Radius Turn away LEAD ; "), 275, 0) +
If(Contains($string), " ; Radius Turn away HANDS ; "), 0, 0) +
If(Contains($string), " ; Revisit LEAD Abort ; "), 0, 0) +
If(Contains($string), " ; Revisit Radius Abort ; "), 0, 0)
When a multi-select field is converted to a string all the selected options are concatenated together with the three characters " ; ". If you append and prepend these tree characters to the text version of the field you can successfully use Contains() to test for a particular value.
Try this:
var Text string = " ; " & "ToText([Radius Fees]) & " ; " ;
If(Contains($string), " ; Cable Abort ; "), 0, 0) +
If(Contains($string), " ; Greater than 24 - No date ; "), 0, 0) +
If(Contains($string), " ; LEAD Abort ; "), 0, 0) +
If(Contains($string), " ; HANDS Abort ; "), 0, 0) +
If(Contains($string), " ; RADIUS Abort ; "), 100, 0) +
If(Contains($string), " ; Missing Cable - LMI ; "), 400, 0) +
If(Contains($string), " ; Missing Cable - Radius ; "), 0, 0) +
If(Contains($string), " ; Radius Turn away LEAD ; "), 275, 0) +
If(Contains($string), " ; Radius Turn away HANDS ; "), 0, 0) +
If(Contains($string), " ; Revisit LEAD Abort ; "), 0, 0) +
If(Contains($string), " ; Revisit Radius Abort ; "), 0, 0)
When a multi-select field is converted to a string all the selected options are concatenated together with the three characters " ; ". If you append and prepend these tree characters to the text version of the field you can successfully use Contains() to test for a particular value.