Feb 11, 2004 #1 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?
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?
Feb 11, 2004 #2 synapsevampire Programmer Mar 23, 2002 20,180 US 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 Upvote 0 Downvote
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