How Can I Save A Calculated Number and Recall It Later 1

[ihda]

I am using Crystal 8.5 - In the footer of my group (I'm grouping by a category code) I have these formula fields:

Total-by-Category-code
sum ({am1_txt.mor-amt},{am1_txt.category-code})

Total-by-1010
if {am1_txt.category-code} = "1010" then {@Total-by-Category-code}

Total-by-1050
if {am1_txt.category-code} = "1050" then {@Total-by-Category-code}

Total-1010-and-1050
if {am1_txt.category-code} = "1050" then {@total-by-1050} + {@total-by-1010}

The total-1010-and-1050 does not pick up the "1010" amount.

Example:
total-by-1010 = 100
total-by-1050 = 50
total-1010-and-1050 = 50 (The total should be 150)

I am fairly new to the formulas and I may not be using them effectively.

Thank You

 

[glauco]

Hi, I think that you should use a Running Total in for the formula. Read and Try it.

 

[ihda]

Thank you Glauco. The running total resolved the problem.

 

[dcm]

ihda: As an alternative you could try this:

Total-1010-and-1050
if ({am1_txt.category-code} = "1050" or {am1_txt.category-code} = "1010&quot then {@total-by-1050} + {@total-by-1010}
David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner