Making running total of formula field

[stx]

Hi

I have following problem.
In my database i have a table of articles.
I show following columns on my report:
artnr,description,price,tax percentage.
The records are grouped on tax percentage.

In my group footer i show the running total of my price column.(totprice)
What i also show in my group footer is a formula field showing the running total of my price column (totprice) multiplied by the tax-percentage of that group.(i called this field totpricetax)

Now at the end of my report i want to show the running total of that formula field (totpricetax) but i doesn't seem to succeed in it.

Anyone any thoughts?

 

[kenhamady]

You would have to use the 3 formula technique to accumulate these values. See faq149-182.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[kenhamady]

If the following are database fields, you might also be able to write a formula that is simply:

detail price X tax rate for the group

And then simply insert a grand total of this formula. Depends on why you are using running totals.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com