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
Thanks for the reply Dan! Quick follow up.
My fields are Formula Numeric and the Formula analyzer is having an issue with the Var statement saying its text but it expects numeric. How do we get around that?
Thanks!
My fields are Formula Numeric and the Formula analyzer is having an issue with the Var statement saying its text but it expects numeric. How do we get around that?
Thanks!
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)
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)
