Compare dates to return a value (KPI)

[ingbra]

I' new at this, and I want to compare the estimated delivery dates to the actual delivery dates and return a value that can be used to measure to a %KPI. I get an error message for the records that are null.

Expression.Error: We cannot convert the value null to type Logical.
Details:
    Value=
    Type=Type

Can I only use TRUE or FALSE as output?

[MarcelBeug · Accepted solution]

You can have null as output for logicals.

However, if you want to test on that logical, you get the error you mention.