AnsweredAssumed Answered

Average based on one group of values

Question asked by SeanLang on Mar 22, 2014
Latest reply on Mar 22, 2014 by SeanLang

Title

Average based on one group of values

Post

     Hi,

     I have my basic three layer DB:

     Projects

           Buildings

                 Issues

     I have the user enter the progress of the buildings construction (0 - 100%)

     I need to be able to get an average of all buildings progress within ONE project.

     so, if there are four buildings within one project, i need an average of the four buildings only. I am not sure how to write the average function which is Average ( field { ; field }). For some reason, when I try to use this with just the field name in the brackets, I only get the first buildings number, not the entire set.

     Why does it have (field { ; field})? why field twice? am I supposed to enter something for each "field"?

Outcomes