cancel
Showing results for 
Search instead for 
Did you mean: 

How to supress the #ERROR-message?

former_member318041
Participant
0 Kudos

I have a field [Gesammte Problemzeit], that displays the time between two timestamps.
[Gesammte Problemzeit] = [PRM Close time] - [PRM Open time]

If [PRM Close time] does not exist, I receive an error:


The error is correct, but I dont want it to be displayed in the resulting field.
How can I supress this error?

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor
0 Kudos

use this.

=if(iserror([Gesammte Problemzeit])) then ""else [Gesammte Problemzeit]

former_member318041
Participant
0 Kudos

Easy! - Thank you so much!

Answers (0)