Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Count NULL Records


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}

Former Member
Former Member replied

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?

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question