Why does sorting Effort Forecasts by Priority not produce a numerical sort if you are in Hierarchy Mode?

A double-click in the Priority title cell on Effort Forecasts means “Sort Effort Forecasts on project priority order (ascending or descending).” It does NOT mean “Sort Effort Forecasts on the values in the column.” The Project Demand sheet for example is always sorted in ascending project priority order. Project priority order is created by sorting first on Priority and then on Project Name. In hierarchy mode this means that the level 1 projects (programs) are sorted in that priority order. Then all their sub projects are sorted in priority order under them.

This project configuration

Project       Priority          Parent

Baker               15             Delta

Able               100

Delta             100

XRay            4000            Able

Looks like this in hierarchy mode:

Project       Priority          Parent

Able               100

    XRay          100.4000   Able

Delta             100

    Baker        100.15        Delta

Because some projects may not have assignments, it is possible to create the following apparently incorrect sort on Effort Forecasts.

Required Skill    Project    Priority

EE                        Xray         100.4000.

EE                        Baker       100.15.