List.Count(Text.PositionOf

[Tob_P]

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 return many thousands of errors for the fields that contain BOQ or DQ. Can anyone advise of an amendment to make to the custom column formula that would ignore DQ/BOQ and stop the errors?

Thank you.

[Tob_P · Accepted solution]

@HotChilli 

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]

Can 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?