ADDING RESULTS OF RUNNING TOTALS

[apples]

Hi, I am running on crystal 8.0
I have a single table report which has 4 running totals all in the same group footer.
What I would like to know is how can I add the results up I have created a formulae which looks like this..
({#InvoiceTOT}+{#CASH}+{#JournalTOT}-{#DISBTOT})
I popped this in the same group footer next to my last running total, but I am getting blanks nothing is displaying - Help please
Thanks
Sonia

 

[synapsevampire]

This may be a timing issue, in that the formula is being calulated first, I'm not sure.

One solution is to build another Running Total which does combinatively what the others do.

You might also try:

EvaluateAfter({@SetVariable})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Madawc]

I think it's because of the order in which Crystal calculates things. If you put the formula in your detail line, you can then sum the result for your total. Madawc Williams
East Anglia
Great Britain

 

[apples]

Sorry I dont think I am using this right. Thanks guys for such a prompt response.
Madawc, I am using running totals, so I am not using the details line at all so I cannot use your suggestion.

synaps... how do I do this evalulate after..sorry not so clued up here. I need 'baby' talk...where do I put it in my formulae...

Sonia

 

[synapsevampire]

Place it in the beginning of the formula, as in:

EvaluateAfter({#InvoiceTOT});
EvaluateAfter({#CASH});

Not positive that this will resolve, but I think so.

You might also create a Running Total that does the same as the others combinatively.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[apples]

Hi synaps...
Sorry your suggestion was just not working for me however managed to solve it.. It was the system was not seeing the blank or isnull fields, so I had to add the running totals into formula's using the isnull option . Then once this was done voila... my figures were there. Firstly I tried to use the format option and the Report settings but this way did not work either.
Thanks once again for the prompt responses
Enjoy your day
Sonia