Forum Discussion
BiffStockdale
Qrew Trainee
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!
BiffStockdale
6 years agoQrew Trainee
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!
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!