How can my running total not count the null values?

[a211097]

I’m doing a running total to count the number numeric values in a column for a report but there are also NULL values in this column as well. The count is counting the null values as “1” as well as the values I want to count.

How can my running total not count the null values?

 

[BeeBear]

In the running total expert
In Evaluate, select "use a Formula"

Then put
not(isnull({FIELD_NAME}))

If these are NULL fields, it will exclude them but if they are blank fields you would need to put

Not {FIELD_NAME} = ""

Hope that helps


regards

BB

*** Count your blessings not your problems******