Forum Discussion

ingbra's avatar
ingbra
New Member
9 years ago
Solved

Compare dates to return a value (KPI)

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?

  • You can have null as output for logicals.

     

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

     

1 Reply

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion

    You can have null as output for logicals.

     

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