Forum Discussion
Solved
Problem with conditional column
Hi. I have a problem making Conditional Columns work. Have a column with values from 0-100 and some blanks. I just want all the rows that contain a number to have text and the blanks to be em...
The cause of the problem is that you test the values if they are > 0, which won't work for nulls.
Options:
- Test if the value = null
- Test if the value <> null
- Test if the value is a number (via "Add Custom Column", not "Add Conditional Colum")
= if [Satisfaction Score] = null then null else "String" = if [Satisfaction Score] <> null then "String" else null = if [Satisfaction Score] is number then "String" else null
I've tried that and it just wont accept it. I get an error.
Show me the settings for the custom column again now that you've changed them.
It looks like this.
Is there a Change Data Type step after you add this column? When I create a column with the same settings it works fine.
No, There are no further steps. And if I change the type manually, the errors persist. I've created conditional columns before, but have never had this issue.