Skip to Content
avatar image
Former Member

Count NULL Records

Hi,

I am trying to count null records in the email field by using a running total. However, the running total is not calculating it correctly. I am using SQL Server and I have checked the database to make sure the cells are actually null and are not blank. What formula do I need to use to get the running total to work? I have tried isNull() and that didn't work. Here is my current formula:

{vwGenPatInfo.Patient_Email} = "" and

Next ({vwEncounterForms.Patient_ID}) <> {vwEncounterForms.Patient_ID}

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 22, 2010 at 03:35 PM

    1) Is this a running total field or did you create a manual running total?

    2) Why are you comparing the next record?

    3) Do you have "Convert NULL values to Default" turned on in your report or global options?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks. I checked "Convert NULL values to Default" in the report options and it wasn't checked. I turned it on and the running total now works perfectly. I am using a built-in running total, not a manual one.