harrietohs
IS-IT--Management
Last week, you solved the problem for me when I had to subtract the total count of two groupnames from another groupname, by using the set of formulas at the end of this note.
Is it possible to use something similar for a sum of $ amount field group total on the same report?
What I want to achieve is to deduct the value of those records with status of Held or Terminated, from Status of Active sum.
Here's the set of formulas:
To decrease Active Count by Held and Terminated:
@inittotal
shared numbervar total:= 0;
-Place in Report Header
@accumtotal
shared numbervar total;
if GroupName ({PAW_CC_AMMEND.Gift Status}) = "Active" then
total := total + Count ({PAW_CC_AMMEND.Constituent ID}, {PAW_CC_AMMEND.Gift Status})
else
total := total - Count ({PAW_CC_AMMEND.Constituent ID}, {PAW_CC_AMMEND.Gift Status})
Note: replace groupname and field names as required.
-Place in Group Footer 1
@showtotal
shared numbervar total;
total
-Place in Report Footer
Thanks,
Harriet Farmer
Ottawa Humane Society
Is it possible to use something similar for a sum of $ amount field group total on the same report?
What I want to achieve is to deduct the value of those records with status of Held or Terminated, from Status of Active sum.
Here's the set of formulas:
To decrease Active Count by Held and Terminated:
@inittotal
shared numbervar total:= 0;
-Place in Report Header
@accumtotal
shared numbervar total;
if GroupName ({PAW_CC_AMMEND.Gift Status}) = "Active" then
total := total + Count ({PAW_CC_AMMEND.Constituent ID}, {PAW_CC_AMMEND.Gift Status})
else
total := total - Count ({PAW_CC_AMMEND.Constituent ID}, {PAW_CC_AMMEND.Gift Status})
Note: replace groupname and field names as required.
-Place in Group Footer 1
@showtotal
shared numbervar total;
total
-Place in Report Footer
Thanks,
Harriet Farmer
Ottawa Humane Society