Hello to everybody, I display the next information, to ilustrate what I need:

amount1 cred. amount2 perc. cred. amount3 perc.
-----------------------------------------------------------------------
10,577.80------ 12--- 5,000.00--- 29.30%----12---10,000.00-----16.41%
809,973.87------ 89--- 7,140.61--- 41.85%---- 3----1,198.91----- 1.97% 1,361,363.15------349--- 4,922.79--- 28.85%----41---49,724.52-----81.62%
-----------------------------------------------------------------------
2,181,914.82------450---17,063.40--- 0.78%----56---60,923.43-----2.79%
-----------------------------------------------------------------------
A B C D E

I need to get the result of column C and column E and:
The total of column C is the result of divide the total of column B by the total of column A (percent)
The total of columen E is the result of divide the total of column D by the total of column A (percent)
Calculating in an excel sheet something like this:

(17,063.40 / 2,1811914.82)% = 0.78% and (60,923.43/2,181,914.82)% = 2.79%

What instruction do I have to write to operate the column totals..???
The code to calculate all columns are right, I have the problem just in the column total, please I need suggestions...!! Thanks..!!

Product: Webfocus 7.1.1

Hi Marielos,

Use the RECAP command. It allows you to recalculate the column totals in a subfoot, which should give you what you are looking for.
It is well documented in the Creating Reports manual.

Kevin

Thank you Kevin...I'll try to use that command, and if doesn't work I'll tell you the results..!!