Best Of

Alternatively you can use can type ``` and a code block will pop up for you.

Hi @arzconci if you click the paragraph icon on the left side of the text editor, it opens more text format options:

@arzconci Without seeing your actual data and results, the first thing that stands out to me is the OR in your criteria for 'MISS'. When you are using OR operators, be sure to use parenthesis to group relevant criteria. For example, if both of the statements before and after the OR must be true, then it should look like this:

   when ( `actual arrival at pod date` is not NULL

   AND

   (DATEDIFF(`actual departure from pod date`,`actual arrival at pod date` ) > `Port free time`) )

   OR

   ( `actual arrival at pod date` is not NULL

   AND

    (DATEDIFF(`current date`,`actual arrival at pod date` ) > `Port free time`) )

   THEN 'MISS'