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.

  • I am having a similar issue. After reading several blogs with other users having similar complaints, I'm beginning to think this is a software glitch. :-(
    – user21212
    Nov 18, 2015 at 15:58
  • Having exactly the same problem but on the FINISH field. On the custom report choosing Sort by FINISH (Asc or Desc) does not result in an ordered list.
    – Lynn
    May 15, 2017 at 23:05

2 Answers 2


I cannot reproduce the error. In Duration1 I have the following formula based upon your earlier post:

IIf([Baseline1 Finish]=ProjDateVAlue("NA")Or Not IsDate([Finish]),0,IIf(ProjDateDiff([Baseline1 Finish],[Finish])<0,0,ProjDateDiff([Baseline1 Finish],[Finish])))

I see any negative values turned to zero and any positive values calculated.

I create the report adding a table showing Task name, Start, Finish, % Complete, and Duration1. I sort on duration1 and all works as expected.

Please make sure you are up to date on all updates: http://blogs.technet.com/b/projectsupport/p/msp13.aspx

  • Thanks for the idea. I am at 15.0.4745.1000 so I should be up to date. I'll keep tinkering to see if I can find anything that seems to affect the behavior and will report back.
    – JimMSDN
    Aug 26, 2015 at 14:43
  • Does this occur in all files? If you create a new file does the problem persist?
    – JulieS
    Aug 27, 2015 at 19:22

I found an answer over in MS Community by sdickinson72:

The fix for this is to add a group then sort by date.

I.E. to show all milestones in date ascending add a group to the filter to group Milestones = Yes, remove any hierachy and then sort accordingly.

  • Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.
    – Community Bot
    Mar 8, 2023 at 2:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.