I am using CR XI
In the below formula, I would like the formula to stop the calculation after the stringvar PassFail result is either "Pass" or "Fail" and continue if the result equals "AIT".
stringvar PassFail;
if CDATE({@Activity Date}) <= DateAdd("d",1,CDATE({INTAKE.DECISION_DATE}))
and {ACTIVITY_LOG_PARTICIPANT.CONTACT_STATUS_CODE} = "COMPLETED"
then
PassFail := "Pass"
else
if CDATE({@Activity Date}) <= DateAdd("d",1,CDATE({INTAKE.DECISION_DATE}))
and {ACTIVITY_LOG_PARTICIPANT.CONTACT_STATUS_CODE} = "ATTEMPTED"
then
PassFail := "AIT"
else
if CDATE({@Activity Date}) > DateAdd("d",1,CDATE({INTAKE.DECISION_DATE}))
and {ACTIVITY_LOG_PARTICIPANT.CONTACT_STATUS_CODE} in ["ATTEMPTED","COMPLETED"]
then
PassFail := "Fail";
In the below formula, I would like the formula to stop the calculation after the stringvar PassFail result is either "Pass" or "Fail" and continue if the result equals "AIT".
stringvar PassFail;
if CDATE({@Activity Date}) <= DateAdd("d",1,CDATE({INTAKE.DECISION_DATE}))
and {ACTIVITY_LOG_PARTICIPANT.CONTACT_STATUS_CODE} = "COMPLETED"
then
PassFail := "Pass"
else
if CDATE({@Activity Date}) <= DateAdd("d",1,CDATE({INTAKE.DECISION_DATE}))
and {ACTIVITY_LOG_PARTICIPANT.CONTACT_STATUS_CODE} = "ATTEMPTED"
then
PassFail := "AIT"
else
if CDATE({@Activity Date}) > DateAdd("d",1,CDATE({INTAKE.DECISION_DATE}))
and {ACTIVITY_LOG_PARTICIPANT.CONTACT_STATUS_CODE} in ["ATTEMPTED","COMPLETED"]
then
PassFail := "Fail";