Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is this possible to do ?

Status
Not open for further replies.

Crystalfire

Programmer
Jan 29, 2002
315
US
I have Two ( 2 ) formulas called @NEW XXX and @Show This Amount Credit

I hope I can explain this right, but what I need to do is have a Cumulative sum of both formulas shown as Need This EX:

@NEW XXX @ Show This Amount Credit Need This

0 15,927.28 -15,927.28
0 41.20 -15,968.48
0 15.99 -15,984.47
15,927.28 0 -57.19
57.19 0 0

Crystal 8.5
 
Create a pair of running totals, that sum values using the same criteria as @NEW XXX and @Show This Amount Credit.

Have a formula field that adds the two. Show this value.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
yes you can use the previus option

eg.

previous({@New}) + {@AmountCredit}

or viceversa

Mo
 
What I really need is the amounts shown as they are added up. As shown in my Ex; Need This
 
Try Madawc's solution. If the formulas are not available for use in the running total expert, then you must share the contents of each of your formulas and explain your report structure.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top