Former Member

# Sum the Sum total values above

Post Author: John Patterson

CA Forum: Formula

I have created a report that contains a list of values (in a group) that come from a formlar that has Sum {} totals in it. All I want to do is sum that list into one value below, just like Excel would do!

Crystal won't allow me to sum the results of group sum totals higher up the report. I have been told that I need to create a conditional running total or a set a variable to store the values required.

Any ideas?

Many thanks

John

10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on Nov 20, 2007 at 04:17 PM

Post Author: fusion

CA Forum: Formula

Hello John,

I also have the same trouble. Why does crystal not let me sum the values of the filed which gets its values by addition of two different fields?Please advise. Thanks

10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 20, 2007 at 06:28 PM

Post Author: Lugh

CA Forum: Formula

Er, yes. You need to do a conditional running total, or use variables. Were you looking for ideas on how to do that? Try checking out http://www.tek-tips.com/faqs.cfm?pid=149&fid=182 Or, alternately, create a new formula that sums up the figures from scratch.

10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 20, 2007 at 07:05 PM

Post Author: Jami_Benson

CA Forum: Formula

I had something similar to this. I was trying to sum a count field. What I ended up doing was using a running total for the count and then summing the running total. So I guess what I am saying is that yeah a running total is your best answer. Jami

10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 20, 2007 at 09:43 PM

Post Author: fusion

CA Forum: Formula

Definitely Jami,I found out that Running Total is an answer. I still need to find out how to get a percentage of the total using a running total. When you use a summary option then there is a option that allows you to have the filed as a % of the total of that filed. How can you do the same using running total. I am trying to work with formulas but no any luck so far.Your help is highly appreciated

10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 21, 2007 at 08:05 PM

Post Author: John Patterson

CA Forum: Formula

Thanks, but that site is closed!?

I've not done too much with variables and someone suggested that I will need an array variable to store each result and then some the results together. Beyond my experience I think.

Regards

John