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
    Icon for Community Champion rankCommunity Champion

    You can have null as output for logicals.

     

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