I have a file with a field called Active Status that tests the status of the person represented in each record. This field is defined as:

Case(Status of Participant = "Deceased", "Deceased",

(Status(CurrentDate)-(Attendance Records::Date of Event) <183), "Active (6 Mo.)",

Status(CurrentDate)-(Attendance Records::Date of Event) <365, "Active (12 Mo.)",

Status(CurrentDate)-(Attendance Records::Date of Event) <548, "Active (18 Mo.)",

Status(CurrentDate)-(Attendance Records::Date of Event) <730, "Active (24 Mo.)", "Inactive")

The result will not show. It is not hidden behind anything, and it is defined as a standard field. So I created a new field called Active Status A with this definition:

Active Status

This field displays the result of the first field just fine. Why doesn't the first field display?

It workded for me. Is the result of your calculation "Text"?

Hi Lee -

Yes it is for both fields.

Regards,

John

Hi John,

This is what I have.

Status of Participant = Text

Date of Event = Date

c_Status = Text Result

Case(Status of Participant = "Deceased", "Deceased",

(Status(CurrentDate)-(Date of Event) <183), "Active (6 Mo.)",

Status(CurrentDate)-(Date of Event) <365, "Active (12 Mo.)",

Status(CurrentDate)-(Date of Event) <548, "Active (18 Mo.)",

Status(CurrentDate)-(Date of Event) <730, "Active (24 Mo.)", "Inactive")

Note:

c_Status field needs to be an Unstored calculation.

Uncheck the "Do not evaluate if all referenced fields are empty" box

and because you are using a relationship in your calculation, you might need to click in and then out of the field to see the change.

HTH

Lee