Forum Discussion
kjartank
Helper II
Helper IIProblem 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
kjartankHelper II
Helper III have tried it. Have no idea why it won't work. I just might have to duplicate the column and replace all the values.
MarcelBeug
Community Champion
Community ChampionThe 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
- kjartank
Thanks a lot! :)
I tested for null values first and then went on to check the values. Anonymous's answer helped me with this. Hope this works for you guys too.