How to handle null in custom column?

[ERing]

I have a simple custom column below that is a conversion time in dates. Each of these columns has rows with null, so my custom column also has null. Is there a way I can replace null with blank in my custom column?

column = [lead duration] - [offer duration] - [accepted duration]

[Anonymous · Accepted solution]

Hi @ERing ,

Unfortunately, this is the default. null means blank. null does not represent the text "null" here, so it does not affect the calculation.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[mlsx4]

Hi @ERing 

You can establish an if to check if a value is null. I don't know how your columns are defined, but anyway: if([lead duration]= null then <what you want to return> else [lead duration])

If you want a blank -> then BLANK()

[ERing]

My columns are defined as decimal number.

Is there a way to check just the result of the custom column so that if the result is null, then Blank()?

[mlsx4]

Hi @ERing 

Yes, you can store the result in a variable and then check with an if in this way:

Measure=

var _result= <Your measure>

return IF (_result= null,BLANK(),_result)

But if you want to perform calculus, it is better to return a 0 instead of a BLANK()