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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting conditions for running total formula

Status
Not open for further replies.

crystaldev1

Programmer
Nov 6, 2003
232
US
Hello. I'm using CR 9 and I have a question regarding setting conditions for running total formula. In the "Evaluate" section, I would like to use both "On change of field: Payment.key" and "Use a formula: PaymentType.name = Cash". I am only able to check one option from the "Evaluate" section. I would like to know if there is a way to incorporate these two conditions into a formula by selecting "Use a formula" option. Thank you so much.
 
Use a formula, just make it complex enough to capture your desired evaluation times:

If OnFirstRecord and {PaymentType.name} = "Cash" then true
else
If {PaymentType.name} = "Cash" and Previous({Payment.key}) = {Payment.key} then true
else false

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top