For my report, I am trying to generate monthly fees of $75 per million people of population and rounding up to the dollar. The report is composed of different companies in which each company has more than one city related to it. The city is listed under the appropriate company along with population data. I would like to be able to run a sum of each company's total populations for all of the cities that are related to them. And then I would like to generate the monthly fee based on that total pop. for the company, and then at report footer calculate the sum of the monthly fees.
What I have so far is the monthly fee for each company is MonthlyFee=Sum(75*([CityPop] and the total pop. per company is TotalPop=Sum([CityPop]). Those two work the way I want, but I can't figure out how to calculate the total of all of the monthly fees in the report footer. And I would also like the MonthlyFee to be rounded up to the nearest dollar.