Skip to Content
author's profile photo Former Member
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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.