Maybe something like
If(Project = '004','00'&Iterno(),Project) as NewProject,
If(Project = '004',If(Iterno()=1,0.6,0.4),1)*Sales as Sales
(html, codepage is 1252, embedded labels, table is @1)
While Iterno() <= If(Project = '004',2,1);
Now your Project 004 records are split into two records and assigned to 001 and 002 accordingly.
You can make your selections in NewProject to filter these two projects with the assigned values, or use Project to get the original sums.