Skip to Content
0
Former Member
Mar 25, 2015 at 10:14 AM

running total

83 Views

Hi All,

I need to show sum of group running total in report footer.

I need to calculate when disporder is 1 or 2 only.

I created formula like this.

numbervar cftot;

numbervar gcftot;

if {Payments.disp_ordr}=1 or {Payments.disp_ordr}=2 then

cftot:=cftot+sum({Payments.totsales},{Payments.pm_desc});

if {Payments.disp_ordr}=1 or {Payments.disp_ordr}=2 then

gcftot:=gcftot+cftot;

if {Payments.disp_ordr}=1 or {Payments.disp_ordr}=2 then

cftot;

Here the sum of all groups which is for disp order 1 or 2 is 12938.This I need to show in report footer.

But in report footer I am not getting 12938.

Please help

PFA

Attachments

Untitled.png (236.0 kB)