Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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!
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!
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?