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

running total on a conditional formula

Status
Not open for further replies.

mwhalen

Programmer
Oct 31, 2000
217
0
0
CA
can you do this or can you do a running total only on a boolean? And if you can only do it on a boolean can I do it on something like this:

{ALLO.GIFT}<>'AA' or {ALLO.GIFT}<>'BB&quot; and {ALLO.NUM} like &quot;14*&quot;
 
To do a running total on a conditional field (and I understand that you want to total the results of the conditional field and not do the total in the field?) just treat the conditional field as any other. Remember, you can do evaluations and formulas within the running total as well.

Database Man
Defender of Life, Liberty and the pursuit of accurate database reporting! Follow my free tek-tip adventures at:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top