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: 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.
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
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
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