Calculate results of two summary fields
I have a report with two summary fields in sub-summary parts on the layout. The first field is for the total sale amount of the products in the found set (solar system), and the second is the total size of all systems in kilowatts in the found set.
I want to divide the result of the summary fields to get an average price per wattage. I need to know how to grab the result of the summary fields because I tried just making a calculation field to divide the fields but it doesn't give me the results I was expecting.
Any help is much appreciated!