summary of total counts

[abhi900]

hi all,
using crystal 2008..
i have 2 groups..
1st group is different phases
2nd group is different wrkgroups
i want to display total no. of each status under each wrkgroups.
eg.
phase1 open cancelled held closed
wrkgrp1 5 4 1 2

phase2 open cancelled held closed
wrkgrp1 15 3 7 9
wrkgrp2 4 7 8 20

so what i did was the following :-
created formula_closed:
if {workgroup} = 'closed' then 1 else 0

formula_open:
if {workgroup} = 'open' then 1 else 0
etc.

put these formula on the detail sections and right-click, inserted summary into the group footer.

however this now displays the total under each groupheading as for PHASE 2 and so on :-
phase2 open cancelled held closed
wrkgrp1 34 34 34 34
wrkgrp2 39 39 39 39

please advise why is it not displaying as per the status and why just the total ?

regards
abhi

 

[Madawc]

Are you using 'Count' rather than 'Sum'? That would explain it.

You could have got the same result more easily using running totals with formulas. These have the advantage that you can display them on detail lines if they seem not to be working, and find what is or is not added.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

As Madawc suggests, you should use sum, not count, since a count will just count the number of times the formula executes, not the number of records meeting the conditional criteria.

-LB

 

[abhi900]

thank u all..!! and yea i did change to sum and got it right..!!
however.. when i tried using running totals.. its still not working..?? hmmm i mst be doing something.. wrng..

thanks..