In 14.0, when the progress values were made consistent, a data migration was done to transform all progress values of all work packages to make them consistent. To do so there were some general rules: as the % Complete value is always a derived value in 14.0, it makes sense to preserve Work and Remaining work in 14.0, and make % Complete a derived value.

In 14.6, we'll make [% Complete editable again](https://community.openproject.org/projects/openproject/work_packages/52233/activity), and we want to preserve that value more than before. For people not having made the jump to 14.x because they feared losing their % Complete value, we'll update the data migration so that Work and % Complete are preserved, and Remaining work is derived. It better reflect how the application is working now with regards to the progress values.

This only applies if the progress calculation mode is Work-based.

**Acceptance criteria**

* In Begin of the insertiondisabled mode (pre-14.0 option where % complete was hidden)

* Discard all % Complete values and derive % Complete from Work and Remaining work when possible

* InEnd of the insertion work-based progress calculation mode

* When all 3 values are set and inconsistent, Remaining work is derived from Work and % Complete

* When 2 values are set, the third one is derived from the two others

* If Remaining work is greater than Work, Remaining work is set to Work and % Complete is 0%

* When 1 value is set

* If it's % Complete, leave Work and Remaining work empty

* If it's Work or Remaining work, the other work value is set to the same value and % Complete is set to 0% (except if Work is 0h, in which case % Complete is unset)

* In status-based progress calculation mode:

* No changes