Forum Discussion
Solved
Replace (BLANK) by a string on a numeric column
Hello. I have the following sample table where the hightligted colum stands for number of days that separates us from the target. Obviously, this column needs to be numeric, because in...
Neandril , if you need a string, then the other also need to be a string. You can only have one datatype
My Formula =
var _diff =
IF(
Table[Col] >= .1,
DATEDIFF(Table[Date1], Table[Date2], DAY)& "", "No Value"
)
RETURN
_diff
amitchandak
Super User
Super UserNeandril , if you need a string, then the other also need to be a string. You can only have one datatype
My Formula =
var _diff =
IF(
Table[Col] >= .1,
DATEDIFF(Table[Date1], Table[Date2], DAY)& "", "No Value"
)
RETURN
_diff