totaling all items for a group 1

[crachic]

I am using crystal XI.

I have a field that has three values (I,O,P) and is a static field where nothing will ever change with this field. It is hardcoded.

I currently have formulas working that total up the number of episodes for each value (I,O,P) by means of grouping by this field.

I also need to do a total of all of these combined. I know that I can recreate my formulas (taking out the reset on group feature) and put them in the report footer. Not efficient at all. The problem is that I have about 300+ formulas that I really do not want to recreate.

Is there a way to get the combined totals without recreating these formulas?

A brief example of what I am trying to do is listed below.

Group1: I
# of Episodes: 12
Group2: O
# of Episodes: 19
Group3: P
# of Episodes: 3
Combined Total:
# of Episodes: 34

Please let me know if there is a way of me doing this. I appreciate any and all feedback.

-crachic

 

[lbass]

Why are you using formulas to count in the first place? Can't you simply right click on the episode field and insert a summary (count) at both the group and the grand total level?

For more help, please show the content of your current formulas.

-LB

 

[crachic]

Well, technically I am using Running Totals because I need to count the episodes when three scenarios hold true. Plus I am having them reset after each group.

Any thoughts?

-crachic

 

[kskid]

You can create a grand total running total as well.

 

[crachic]

I assume you mean create another running total and basically do NOT reset on change of group. If that is what you are referring to, that is exactly what I am trying to avoid. I have way to many running totals that I do not want to recreate. If this is not what you are referring to, can you please explain how I would do this. Thanks.

-crachic

 

[kskid]

Are you using a formula in your running totals or just counting records? If you are just counting records, then insert a summary grandtotal.

 

[crachic]

I am using my running total to count records when three scenarios hold true and then I am resetting on change of group. So I guess the answer to your question is no I am not just counting records. The three scenarios are things like when balance > 0 and FC_code = '250' and claim_date < (CurrentDate - 30). These are not the exact ones but I put them there for illustration. I know that I can just create another running total with the same criteria but not restting on change of group, but I am asking if there is a more efficient way.

-crachic

 

[lbass]

Why not just create a conditional formula like the following:

if balance > 0 and
FC_code = '250' and
claim_date < CurrentDate - 30 then
1

Then insert a sum (NOT a count) on this at any group level and/or at the grand total level.

-LB