Field won't display

[John Chamberlain]

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?

[Lee Smith]

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

[John Chamberlain]

Hi Lee -

Yes it is for both fields.

Regards,

John

[Lee Smith]

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