Values replace by "Not Resolved Yet"

[sdhn]

Hi All,

I have calculated column as :

Elapsed = [Resolved Date Time] - [Created]

Many Resolved Date Time rows has no value.

When there is no value its give me result as:

I want to replace this for "Elapsed" column by either no value, Zero (0) or 'NoT Resolved Yet'.

Any help will be appreciated.  thanks 

[smpa01]

@sdhn  you missed the underlined part

VAR _diff = [Resolved Date Time] - [Created]
RETURN IF([Resolved Date Time]=BLANK(),0,_diff)

[smpa01 · Accepted solution]

@sdhn  can you try this

Column =
VAR _diff = [Resolved Date Time] - [Created] 
RETURN IF([Resolved Date Time]=BLANK(),0,_diff)

[sdhn]

Thanks 

[sdhn]

Please see above for error message.  Thanks