Hi Guys,

I've been trying to do a calculation field about if a certain job is overdue by -5days, show me an alert. If its overdue by -10days, display another alert.

I've been trying to do it with the following calculation;

If ( IsEmpty ( paid date ) and days left ≠ date global > -5; "Your Late"; If ( IsEmpty ( paid date ) and days left ≠ date global > -25; "OverDue"; " "))

It only works for 'your late' .. and I'm completely lost. Any help would be much appreciated.

These sorts of formulas work in the order that they are entered so will evaluate first true condition first - try the following formula for the message

(I would replace "days left ≠ date global" with an unstored calc that calcs "overdue days" something like "date global" - invoice date":

If ( IsEmpty ( paid date );

Case(

Overdue days > 25; "OverDue (>25)";

Overdue days > 5; "Your Late (6 to 25)";

"OK (1-4 days)");

"Paid")

I would replace "Your" with "You're". B)

LOL - I saw that too - changed it and changed it back to OPs wording, having decided that as a very "new" person I would probably invite all sorts of invective but now you've said it too! - Actually am more happy that I hadn't made a howler with my comments.

:smile2: