Need help with orderby/select by

[tcanelli]

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.

[Steve]

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)

[tcanelli]

Thank you! How do you know all this?! I wish my brain would absorb it

[Steve]

Years of practice…