Skip to Content

How to supress an #ERROR - message?

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 06, 2018 at 06:23 PM

    Hi Henning,

    Create the below variable
    PR Close Time Blank Flag = If(IsNull([PR Close Time])) Then 0 Else 1

    Then, use that Flag variable, and add a filter on the table as PR Close Time Blank Flag = 1

    Let us know if that works.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded