still having running totals problem

[Former Member]

let me define better. this is placed in the report footer:

IF ({AEMPPF02.IDPRT#} = 'FRTCMB') then

{AEMPPF02.EXTSHP}

it is a running total.

I cannot get anything to total that.

I tried the same thing with no reset it doesnt  work. WHileprinting records is not allowed on a formual it seems.

I am completely

stuck here. Why can't you total a line like this?

[Former Member · Accepted solution]

Abhi is right if you want a grand total at the footer.

If you want a running total at each detail record then you can create a whileprintingrecords formula with a number variable:

whileprintingrecords;
numbervar total_EXTSHP;
if ({AEMPPF02.IDPRT#} = 'FRTCMB') then
total_EXTSHP:= total_EXTSHP +  {AEMPPF02.EXTSHP}

Be aware that you need a “display” formula in your footer:

whileprintingrecords;
numbervar total_EXTSHP;

[abhilash_kumar]

Hi Paul,

If you're trying to show a 'Grand Total' here, simply create a summary on the above formula field and place it on the Report Footer.

Go to Insert Summary > Choose the above formula field > Choose 'Grand Total (Report Footer)' from the drop-down.

-Abhilash