on 11-20-2007 1:37 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.