Hello All!

Sample File Attached. I am having troubles getting this calculation to work properly.

I need to mark Assignment with:

Repetition #2 (Purple) if Assignment Status is “Working” and past due.

Repetition #1 (Gray) if Assignment Status is “Complete” and past due.

Calculation works except for the “Working” past due section.

Even if status field is marked "Working" calc results repetition #1 (Grey)

I do not know how to set the criteria for the Case function in this calc to look for days past AND status.

Please help, thank you for your interest.

Sincerely,

StatusByColor.fp7.zip

Case(

date_deadline - Get(CurrentDate) ≥ 7; GetRepetition(Home::colors; 5);

date_deadline - Get(CurrentDate) ≥ 3; GetRepetition(Home::colors; 4);

date_deadline - Get(CurrentDate) ≥ 0; GetRepetition(Home::colors; 3);

date_deadline - Get(CurrentDate) < 0 [color:red]and txt_status = "Working"; GetRepetition(Home::colors; 2);

date_deadline - Get(CurrentDate) < 0; GetRepetition(Home::colors; 1)

)

:

Ok, the change from "Complete" to "Working" was a duh on my part. Oops, :

BUT!!! What is the difference between "&" and "And"?:

This calc dose NOT work with the "&". Whoa.

Please, if you have a moment, explain.

THANK YOU for your help!

& appends two strings together:

  "ab" & "cd" -> "abcd"

"and" is a boolean operator:

  True and False -> False

  True and True -> True