Every time I change my app, it identifies 2 errors, yet the report has been working perfectly for years, and continues working.
I am confused as to why.
The code that is supposedly in error is as follows, however if I add the code as a variable to a table (my way of testing it), it works fine. [Worker] is the Key field but it is a calculated field in this case, a concatenation of two other fields.
Orderby(Select(Workers[Worker],AND([Worker Type]<> “Suspended”,Count(Select([Related Tickets][Name],[Expiry]<=Today()+30))>0)),[Worker])
This is the other code that reports the same type of error. Here I have shown the full Error message that includes the full START expression I am using.
Start expression 'Select(Workers[Worker],AND(OR(Count(Select([Related Timesheets][Hours],[Work Date]>=Today()-2, true))>0,Count(Select([Related Labours][Hours],[Work Date]>=Today()-2, true))>0,Not(OR([Worker Type]="Suspended",[Worker Type]="_System"))),[Supervisor]=” CAMPBELL, Brian”),true)' should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the 'Key' column of the referenced table
Can anyone help me identify what the error is, and why it keeps working despite the reported errors?
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |