Hello All,
I am must be missing something simple. I want to sum the values in a calculated field.
Gallons is a number
Price per gallon is currency
total is gallons x price per gallon (not stored, it is calculated on the report)
I want to SUM the TOTAL
I tried =Sum([total]) but is does not work. When I open the report I am prompted for that value
Any ideas?
Thanks,
-Mike M