Forum Discussion

Icon for Responsive Resident rank

Responsive Resident

4 years ago

Solved

Values replace by "Not Resolved Yet"

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

sdhn can you try this

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

4 Replies

smpa01
Community Champion
4 years ago
sdhn can you try this

Column = VAR _diff = [Resolved Date Time] - [Created] RETURN IF([Resolved Date Time]=BLANK(),0,_diff)
- sdhn
  Responsive Resident
  4 years ago
  Please see above for error message. Thanks
- sdhn
  Responsive Resident
  4 years ago
  Thanks
smpa01
Community Champion
4 years ago
sdhn you missed the underlined part

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