Skip to Content
0

How to supress the #ERROR-message?

Feb 07, 2017 at 12:31 PM

23

avatar image

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?

prm.jpg (30.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Feb 07, 2017 at 12:51 PM
0

use this.

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Easy! - Thank you so much!

0