on 02-07-2017 12:31 PM
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?
use this.
=if(iserror([Gesammte Problemzeit])) then ""else [Gesammte Problemzeit]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.