Forum Discussion

Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
2 years ago
Solved

List.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...
Need Help
  • Tob_P's avatar
    Tob_P
    2 years ago

    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!

Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
2 years ago

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!