0

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 '15 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 '17 at 23:05
1

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 '15 at 14:43
  • Does this occur in all files? If you create a new file does the problem persist? – JulieS Aug 27 '15 at 19:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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