2 Replies Latest reply on Oct 12, 2019 2:23 PM by Ashton Summers

    Lookup Latest/Fixed Sale Date and Pull Data

    Ashton Summers

      Hello,

       

      I am trying to reference only the latest sale date and pull it's sale price, price per SF (PSF) without filters, but I'm having trouble.

       

      I've tried the following formulas:

       

      1. { fixed Sale Date, Property Address : MAX/SUM/AVG ( PSF ) }

      1. { fixed MAX SALE, Property Address : MAX/SUM/AVG ( PSF ) }

      // Max Sale is simply MAX (Sale Date)

      2. Lookup ( AVG/SUM (PSF), Last() )

       

      I'm basically trying to do a VLOOKUP (or lookup fixed?) without filters/parameters/manipulating the underlying data.

       

      Thank you,

      Ashton