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
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!
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!