Forum Discussion
Tob_P
Helper V
Helper VList.Count(Text.PositionOf
Hi, I have the following Conditional Column looking for the count of occurrences of a CQ prefix. The Quote No column can also have prefixes of BOQ or DQ. So when I refresh my table, I r...
Thanks for coming back to me. Closer inspection revealed the errors where because there were blank values in the column which were being treated as null values which was causing the error. Replaced null with blanks and problem solved.
Probably should have investigated a bit more before I post here!
HotChilli
Community Champion
Community ChampionCan you provide some sample data and explain more clearly what the problem is?
The code is looking for "CQ" and doesn't refer to BOQ or DQ. What errors are you receiving?