How do you count null records

[lcutliffe]

Hi I am working on a report that tallys jobs with Promise Dates. I need to have a percentage breakdown of how many dates were on time but the problem is, some of the Promise date fields on some of the records are blank, so my total doesn't reach 100%. Is there a way I could count the null Promise date records and go from there. I'm trying to get a count on the records that have blanks for Promise dates but have had no luck so far.

 

[CoSpringsGuy]

will the number of dates to reach 100% be equal to the total number of records?

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lcutliffe]

That is correct.

 

[CoSpringsGuy]

then could you use a count field from another field that is never blank? {problem.ticket)

else you could count the null fields this way in a formula

if isnull({date.field}) = true then 1 else 0

i sum of that field will provide a count of null values

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lcutliffe]

That little formula did the trick, Thank you