Calculation Problem

[Mickdn]

Have a Portal containing Players names (Maximum of 6). The Status field shows whether the Player is "Active or In-Active". I'm trying to get the Family Status field to show "In-Active" if all the Players are "In-Active". Currently I can only get it working if the 1st Player in the Portal is "In-Active".

 

Using this calculation "Case (Players::Player Status = "In-Active" ; "In-Active" ).

 

Many Thanks!

[comment]

I'm trying to get the Family Status field to show "In-Active" if all the Players are "In-Active".

 

Try something like =

Case ( IsEmpty ( FilterValues ( "Active" ; List ( Players::Player Status ) ) ) ; "In-Active" )

Note: this is not the best arrangement to have. Active (or Inactive) should be either a Number field, containing 1 if true, 0 or empty otherwise, or a Date field recording the start of activity (or inactivity).

[Mickdn]

Thanks very much, works a treat!