Hello
I have a report showing the dates various activities on a project occurred. We are installing water tanks so I have a date field named TankDate which is the date the tank (or tanks) are installed at a particular property. I also added a field named TotalTanks with the following formula
This counts the number of tanks to be installed per property (FYI - if a property is to receive 2 tanks they are installed on the same day).
The properties are categorized and grouped as Households, Farms, Schools, Polyclinics, Community Tanks.
What I would like to do in the group footer for each category is give the total number of tanks installed.
Can someone please help me with this formula? I tried
but that's not working.
I have a report showing the dates various activities on a project occurred. We are installing water tanks so I have a date field named TankDate which is the date the tank (or tanks) are installed at a particular property. I also added a field named TotalTanks with the following formula
Code:
=IIf([TankDate] Is Null," ",[CountOfSystem]*1)
This counts the number of tanks to be installed per property (FYI - if a property is to receive 2 tanks they are installed on the same day).
The properties are categorized and grouped as Households, Farms, Schools, Polyclinics, Community Tanks.
What I would like to do in the group footer for each category is give the total number of tanks installed.
Can someone please help me with this formula? I tried
Code:
=Sum([TotalTanks])