This is wrong but I can’t figure out why:
<<Start: ORDERBY(SELECT(DEMO Personnel Time Log[TimeLogID],([Agency]=“Department of Health Employee”, [Evac Center], FALSE, [_ComputedName], FALSE, [Check In Time], FALSE)))>><<_ComputedName>>
I want to select on the “depart of health employees”, ordered by evac center, then name. Keep getting invalid input errors.
I had the select expression in their first and the report ran. I only got the errors when I tried adding the orderby. Help.
Your ORDERBY() arguments are inside the SELECT() function.
ORDERBY(SELECT(DEMO Personnel Time Log[TimeLogID],([Agency]=“Department of Health Employee”, [Evac Center], FALSE, [_ComputedName], FALSE, [Check In Time], FALSE)))
should be:
ORDERBY(SELECT(DEMO Personnel Time Log[TimeLogID],([Agency]=“Department of Health Employee”)), [Evac Center], FALSE, [_ComputedName], FALSE, [Check In Time], FALSE)
Thank you! How do you know all this?! I wish my brain would absorb it
Years of practice…
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |