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!
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |