Forum Discussion

ovl's avatar
ovl
New Member
8 years ago

Conditional column - cannot convert the value null to type text

Hi,   I am trying to add a conditional column that shows "complete" when XYZ columns contain a value (0 included), and "not complete" when any of XYZ columns contains a blank cell (null).   I hav...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi ovl,

 

Can you share the formula here please? Did this happen after you added the column?

 

Best Regards,

Dale

ovl's avatar
ovl
New Member
8 years ago

Hi Dale,

 

Thanks for quick reply!

 

Here is a screenshot of what I was trying to explain:

 

As you can see below, when I click "ok", the column is added and works as expected (in the query editor). However, when I close and apply the query, it shows me the error "we cannot convert the value null to type text" and the column is not added.

 

Thanks for your help!

Oriol