Replacing Empty Cells

Question & Answer
, ,
1

Hello,

I’ve attempted to replace empty cells with 100, 100%, or NULL and I am unable to get the syntax to work.

Some examples of what I’ve tried:

(1) ifelse({TOTAL SCORE},‘’,NULL,{TOTAL SCORE})
(2) ifelse({TOTAL SCORE},‘’,100,{TOTAL SCORE})
(3) ifelse({TOTAL SCORE},‘’,100%,{TOTAL SCORE})
(4) ifelse({TOTAL SCORE}=“”,100,{TOTAL SCORE})

All of the empty cells need to be replaced with 100 or 100%.

Thanks!

Empty Fields

2

Hi,

If they are empty, then the column has string as the datatype?

Then you could use ifelse(strlen({TOTAL SCORE})=0,“100”, {TOTAL SCORE})

If it is not a string then

ifelse(strlen(toString({TOTAL SCORE})) =0,100, {TOTAL SCORE})

3 Likes
3

Hi Thomas,

The data type is not a string but numerical. Each column is a calculated field. I’ve found another solution that worked.

Thanks