Add detail formulas in detail section

[pgmr]

Hi
CR 8.5 ODBC to AS400
I have a Trial Balance Report which calculates debits and credits for each GLminor, GLmajor, GL account.
I calc debits with {@ytd}
If {?Period} = 1 and {MSTGL.GYEAR} = {?year} then
Abs ({MSTGL.GD01}) - Abs ({MSTGL.GC01})
else
If {?Period} = 2 and {MSTGL.GYEAR} = {?year} then
(Abs ({MSTGL.GD02})-Abs ({MSTGL.GC02}))+
(Abs ({MSTGL.GD01})-Abs ({MSTGL.GC01})) and so on...
and I suppress if <0
I calc credits with same formula and suppress if >0.
Both formulas are in the detail section.

I added two other colums of debits and credits for a previous year {?year}-1
My detail shows one row for {?year} and another row for the previous year. I need them to be on same row and I need to add up debits for {?year} + {?year}-1.
My report should look like this
{?year}-1 {?year} total
GMAJ GMIN GACCT GDESC DEB CRED DEB CRED DEB CRED

Is this possible?
Thanks in advance

 

[synapsevampire]

What prevents you from placing them in the same row, a grouping?

Try demonstrating example data and expected data rather than text descriptions, a picture is worth...

This is probably all doable, you can certainly create your own running totals, add any formulas up toegther, etc.

Here's an example of a manual running total:

Group Header 1:
whileprintingrecords;
numbervar MyNumber := 0; Resetting it

Details:
whileprintingrecords;
numbervar MyNumber := MyNumber+{table.field};

Group Footer 1:
whileprintingrecords;
numbervar MyNumber Displaying it

-k