Forum Discussion
BiffStockdale
7 years agoQrew 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!
- _anomDiebolt_7 years agoQrew EliteWhich field is Formula Number?
- BiffStockdale7 years agoQrew TraineeI 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.
- _anomDiebolt_7 years agoQrew EliteMy 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?
- BiffStockdale7 years agoQrew TraineeI 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. - QuickBaseCoachD7 years agoQrew CaptainPlease also post your actual code as we are not able to edit screen shots.
- BiffStockdale7 years agoQrew Traineevar 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) - QuickBaseCoachD7 years agoQrew Captainremove the extra "
var Text string = " ; " & ToText([Radius Fees]) & " ; " ; - _anomDiebolt_7 years agoQrew EliteAnd 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) - BiffStockdale7 years agoQrew TraineeThank 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! - BiffStockdale7 years agoQrew TraineeHere 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!