Need help with orderby/select by

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)
1 Like

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

Years of practice… :slight_smile:

2 Likes