Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive 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:       ...
  • smpa01's avatar
    smpa01
    4 years ago

    sdhn  can you try this

    Column =
VAR _diff = [Resolved Date Time] - [Created] 
RETURN IF([Resolved Date Time]=BLANK(),0,_diff)
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity 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's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
4 years ago

Please see above for error message.  Thanks