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