Calculation if a bill payment is overdue

[ultrex]

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.

[Simon K]

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")

[comment]

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

[Simon K]

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: