Skip to Content
0
Feb 09, 2016 at 05:32 AM

How to count only the number of empty rows ?

46 Views

Hi Gurus

I am facing a problem related to displaying the count of specific object([Legacy Postal Code] and [Cleansed Postal code] in my case)which are having empty records.I have used IsNull() but it fails for those set of records which are having Numeric values and not displaying the exact count due to this.The IsNumber() function is not working as well.Could anyone help in providing the solution for this?Attached below the screenshots for reference:

case 1:

case2

case3

The legacy_count formula:

Attachments

img1.png (28.9 kB)
img2.png (13.3 kB)
img3.png (15.9 kB)
img4.png (33.2 kB)