Condition on the List

Question

Hi, 
 I want to check if the status is Start/ In Progress or Completed. 
 
 1. if the list is {"Start"; "Start"; "Start"}, result would be Start 
 2. if the list is {"Start"; "In Progress"; "Start"} or any combination that the values are not the same, result would be In Progress 
 3. if the list is {"Completed"; "Completed"; "Completed"}, result would be Completed. 
 
 please help. 
 Thanks,

Chris · Accepted Answer

For this I am assuming the second #2 (#3?) should result in "Completed"? If so: 
 a!localVariables(
 local!list: {"Start","Start","Start"},
 local!union: union(local!list,local!list),
 
 if(
 local!union="Start",
 "Start",
 if(
 local!union="Completed",
 "Completed",
 "In Progress"
 )
 )
)

Chris · Answer

For a more condensed version of my solution, assuming this is the intended result: 
 a!localVariables(
 local!list: {"Start","Start","Start"},
 local!union: union(local!list,local!list),
 
 if(
 count(local!union)>1,
 "In Progress",
 index(local!union,1,null)
 )
)

Condition on the List

Top Replies