Additive Multi Select issues with contains

Which field is Formula Number?

I have the multi select text and then the six numeric formula fields which look for the items.chosen in the multi select.  Those six are what are getting fed the dollar amounts which is what the IFs determine.

My formula takes the multi-select field [Radius Fees] as input and returns a number as output. I don't see a connection or conflict with the fact that you have six other fields. What am I missing?

I cant save the formula as QB has an issue with the end of the Var statement.  It gives the reason that it is expecting a number but is finding text.  Wont let me save it.



When I try to save it shows a syntax error midway through the first If.

Please also post your actual code as we are not able to edit screen shots.

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)

remove the extra "

var Text string = " ; " & ToText([Radius Fees]) & " ; " ;

And add the three character prefix and suffix:

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)

Thank you both very much.  I never would have thought of the prefix suffix approach.  Additionally, I have noticed that whenever I paste someone else code i dont grasp whats going on very well vs when i write it.  So apologies for having to hold my hand the whole way through this.

Final thought, I needed an extra opening parenthesis on the left of string.

If(Contains(($string), " ; Cable Abort ; "), 0, 0) +

Again, thanks so much for a workable solution!

Here is the final working code for anyone that ends up on this thread with a similar issue.


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)

// Special thanks to Dan D and Mark S!



Again, thanks so much for a workable solution!