how to process data in developing AP account report

[1190_5939_439]

Hi Experts

Background

When I develop AP account report,I meet the following requirment. We will be sure that the posisite number is not found in total and Month.(0 and minus are ok.)

I need process data in internal table from raw data to post processing data.

Logic is following:

line 1.If total is positive. I will delete the row. when the total is 80. I will delete the row ;

line 2.When total is minus(-10) . quantity of January is positive ,and it will equal 0. quantity of Feburary equal that quantity of January and quantity of Feburary are added. (When tatal is -10. The quantity of January is 20. It will equal 0 . The quantity of Feburary is 20+(-1) = 19 )；

If quantity of Feburary is positive, and it will equal 0. quantity of March is equal that quantity of March and quantity of Feburary are added.( The quantity of Feburary is 19. It will equal 0 . The quantity of March is 19+(-1) = 18 );

If quantity of March is positive, and it will equal 0. quantity of April is equal that quantity of April and quantity of March are added.(( The quantity of March is 18. It will equal 0 . The quantity of April is 18+(-28) = (-10 ));

line 3. The logici is same with line 2

The Screenshot is following:

Raw data

Post processing data

Thanks in advance.

[1190_5939_439]

it is very easy that you must use (loop at) and ( if ... elseif ...elseif ... elseif ... endif.)