Calculations using summary fields
I have a 15 year record of monthly water use data from four weather stations. Using a Summary Field I have an average value, by station.
I have a table with constants that are plant (tree or grass) dependent.
Here is my question - How do I set things up so that I can multiply each month’s average value by one of the constants so that the final output is a table, by month and station of water use by a particular plant.