Jump to content

Field won't display


This topic is 7496 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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

cool.gif

Link to comment
Share on other sites

This topic is 7496 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.