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

Base a Running Total on a different criteria

Status
Not open for further replies.

shaleen7

MIS
Jun 23, 2002
188
US
I want to base my running total on every app date field that is not null. How can I apply this criteria to a running total?
 
Use the evaluate->Use a Formula section and place:

not(isnull({table.date}))

This assumes that you are using a Running Total field.

If you want to eliminate all of the rows with null dates from the report place the same formula in Report->Edit Selection Formula->Record

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top