IFNULL(LOOKUP(SUM(Number of Records),0),0)
This didn't work, as there are no rows of data in question. It's not that there are nulls - it's that there's nothing.
Did you try this?
ZN(SUM(Number of Records))
If Possible, Please paste a workbook, may be with fake data, It is doable.
Yes, I tried with ZN function as well. But it didn't worked!!
Then We need a workbook