Record Label if Child Calc

[Dr. Evil]

Hello!

I need a calculation that automatically labels parent record based on the label of it's children.

For Example:

Parent A ONE = "ACTIVE"

child A 1 = "working"

child A 2 = "complete"

child A 3 = "On Hold"

Parent B TWO = "CLOSED"

child B 1 = "complete"

child B 2 = "complete"

The current calc I have for this is:

Case(child::txt_status = "Working" or "On Hold"; "ACTIVE"; "CLOSED")

I have an attached model file using this calc. But is it right?..

I do not know how stable this calculation is, or if it is the best way of getting the desired result. This seems to work in the sample file, but not in the actual DB. I may have just used a wrong relationship somewhere tho, I have not investigated.

But... I would appreciate any feedback.

THANK YOU!

[RalphL]

The current calc I have for this is:

Case(child::txt_status = "Working" or "On Hold"; "ACTIVE"; "CLOSED")

You have 2 problems with this calculation: 1 it only works on the first related record & 2 it only checks "Working".

It should read Case(child::txt_status = "Working" or child::txt_status = "On Hold"; "ACTIVE"; "CLOSED")

I replaced your calculation with:

Case ( PatternCount ( ValueListItems ( Get ( FileName ) ; "CurrentStatus" ) ; "Working" ) or

PatternCount ( ValueListItems ( Get ( FileName ) ; "CurrentStatus" ) ; "On Hold" ) ;

"ACTIVE" ; "CLOSED" )

The value list CurrentStatus uses related values from the field

Child::txt_status starting from Parent. It does not refresh without a little help.

[comment]

Here's another approach that does update instantly.

AggregateStatus.fp7.zip

[RalphL]

Very Good!