Solved Count blank detail sections in report to minus from grand total

[Jomat]

Hi all. I have a report that have transactions in the detail sections.
Such as date, amount and etc.

I have a grand total count at end of the report. Some records does not have any transactions but shows a blank detail section with empty fields. I need the empty fields to show that no transactions were conducted for that customer.

The problem is that the emtpy spaces are also counted in my grand total.

Does anyone know how I can count the empty spaces and then minus it from my current grand total?

My current grand total formula is:
=Count([T_Date])
I'm Trying to add something like:
=Count([T_Date])-Count([T_Nulls])

With [T_Nulls] as the count of all the blank records.

 

[Jomat]

I actually solved this. Pulling from a query, my report won't take the assigning of value count to each detail record and grand total in the footer won't reference the value field. But instead, when i use an iif statement to assign a value to the unbound field then I assign a 1 if the field is blank and a 0 is isnull and set it to a running sum overall. My grand total just set to equal normal count all records minus the blank count field in the detail section, everything works.
I dont know why though..