AnsweredAssumed Answered

Calculations using summary fields

Question asked by mjroberson on Nov 26, 2013
Latest reply on Dec 5, 2013 by philmodjunk

Title

Calculations using summary fields

Post

     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.

      

     thanks

Outcomes