I've created a simple custom report in Microsoft Project 2013 with a task table that I'd like to sort on Duration1, which happens to be calculated from a formula (as described in #ERROR in User-Defined Field Formula Even After Testing Against ProjDateValue('NA')). Going from "No Sort" to sorting on this field does change the order of the tasks in the table, but they don't seem to be in any particular order - and most certainly not in ascending order. Changing the sort order to descending on this field again re-orders the tasks - but not in correct descending order. I've found other references to similar problems (c.f. http://www.mpug.com/forums/topic/project-2013-sorting-by-date-duration-etc-not-working-in-custom-report/) but without any solution. Am I missing something or is this just a Project 2013 defect?
The report happens to use a custom task filter, but taking that off doesn't seem to make a difference in correctly sorting. Same is true when changing the outline level.