Dynamic Past Due Marker

[Dr. Evil]

Greetings! Sample File Attached.

SYNOPSIS:

Calculation field clc_marker works except for the “Working” past due Case.

I need Assignment clc_marker to dynamicly:

Label assignment with “TARDY” if Assignment Status is “Working” and past due.

Label assignment with an “X” if Assignment Status is “Complete” and past due.

FAULTY CALCULATION:

Case(

date_deadline - Get(CurrentDate) ≥ 0; date_deadline - Get(CurrentDate);

date_deadline - Get(CurrentDate) ≥ 0 and txt_status = "Working"; "TARDY";

"X"

)

Please help, thank you for your interest!

Sincerely,

DynamicPastDueMarker.fp7.zip

[CobaltSky]

Dr Evil,

In Case( ) expressions, the result associated with the first true argument is returned. Since the first test in your formula is a subset of the second, it will always be returned (ie in all cases where the first argument is valid).

I suggest you try re-ordering the expression and adjusting the arguments (so that the first test checks if the due date has passed). Eg:

Case(

date_deadline < Get(CurrentDate) and txt_status = "Working"; "TARDY";

date_deadline ≥ Get(CurrentDate); date_deadline - Get(CurrentDate);

"X"

)

If I have correctly understood what you're trying to do, that should get you closer to the desired result.

[Dr. Evil]

Thank you CobaltSky

I appreciate your explanation!

I have posted a finished working solution at:

http://fmforums.com/forum/showpost.php?post/263724/