Forum Discussion
Filter a blank from a column
ColumnName =
6 Replies
Hi Anonymous
your _test variable returns BOOLEAN what that cannot be used as second argument in DATEDIFF()
what value do you need there?
whats your desired result for row with Contracten[Verwachte datum contract km bereikt] <> BLANK() ?
HI az38 I would try the value (date) of the rows except the blank rows of Contracten[Verwachte datum contract km bereikt]
Regards,
EzzAnonymous
maybe it will be enough to try a simple version of yours statement? Like
ColumnName = IF( Contracten[Verwachte datum contract km bereikt] <> BLANK() && DATEDIFF ( UTCTODAY (); Contracten[Verwachte datum contract km bereikt]; MONTH ) <= 4; "EindContractKM "; BLANK () )
Try ISBLANK() instead of <> BLANK().
VAR _test = ISBLANK(Contracten[Verwachte datum contract km bereikt])Also, are you sure it is blank? You might want to read this article on blanks, nulls, empty (""), etc.
EDIT: I didn't notice how you were using the variable later. I think az38 has nailed the issue.
Hi edhans, I tried this already and didnt get the right result
