Counting null value

[jtr9999]

thread767-1596997

lbass
The formula's you posted in the thread referenced helped me in my report but I have a question why my original formula didn't work when I did a count on it. I show termination date for a person if they have a termination date and are not active. When I do a count on my original formula it counts every record. Why does it do that?

ORIGINAL FORMULA
If {TABLE.EESTATCD}<>'A' and not isnull({TABLE.TERMDATE}) then
totext({TABLE.TERMDATE})
else
''

WORKING FORMULA
If {TABLE.EESTATCD}<>'A' and not isnull({TABLE.TERMDATE}) then
totext({TABLE.TERMDATE})
else
totext({@null})

 

[lbass]

When you insert a count on a conditional formula, it counts every time the formula executes, not how many times a row meets the criteria. In the first formula, the formula executes when the result is "", and so is counted, but nulls (as in the second formula) are not.

-LB

 

[jtr9999]

Excellent. Thanks for the help.