How to convert a true/false expression to a list expression

Hi there! Can anyone give an idea how to convert the following Yes/No expression to a List expression? I suppose it’s in the Select portion, but I’m feeling a bit heady now

AND(
Max(Select(Timesheet[% Complete],AND(
ANY(Select(MySetLocation[Location],TRUE))=[Tower],
[Work Type]=[_ThisRow].[Type],
IN(ANY(Select(Data[Link1CableID],[Location Name]=ANY(Select(MySetLocation[Location],TRUE)))),[Cable ID])
)))>=80.00
,
Max(Select(Timesheet[% Complete],AND(
ANY(Select(MySetLocation[Location],TRUE))=[Tower],
[Work Type]=[_ThisRow].[Type],
IN(ANY(Select(Data[Link1CableID],[Location Name]=ANY(Select(MySetLocation[Location],TRUE)))),[Cable ID])
)))<100.00
)

Thanks for any response and your infinite patience!

0 4 295
4 REPLIES 4
Top Labels in this Space