Statu Column Calculating

[erhan_79]

Hi there ;

I need to create  a column which is calling " statu"  in my below table .Could you pls help to create to me .

Rules will be like that ;

System wil check based on order number ; 

• IF for each order ;  all the order line's Result column are TRUE , for each order  all statu lines will be "CLOSE"
• IF for each order  all the order line's Result column are FALSE , for each order all statu lines will be "OPEN"
• IF for each order even one of the order line is FALSE , for each order all statu lines will be "OPEN"

For each order to seem that statu is "Close" ,  main rule is all the lines result must be TRUE , if not for each order status mut be "open"

you can see below example also 

[amitchandak · Accepted solution]

@erhan_79 , Create a new column

New column =
var _cnt = countx(filter(Table, [order number] =earlier([order number]) && [result] ="FALSE"),[order number])+0
return
if(_cnt >0 , "FALSE", "TRUE")

Use binary true false if needed