4 Replies Latest reply on Jun 11, 2018 1:48 PM by Deepak Rai

    Average Calculations

    Matt Wilson

      Hi,

       

      I'm trying to create a view that shows an average sales price/sqft for all three lots in the data set. A nuance is that each lot may have multiple transactions affecting sales price. See the data below.

       

       

      My first view is able to accomplish it using the following formula. SUM([Sales Price])/MAX([Sqft])

       

      However, once I remove the lot's from the view, I see that the calculation is 712.20. I can't figure out how to make it show 248.72 ( the real average), once I move the lot#s out of the view. Please help. Thx.