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

    Lookup Latest/Fixed Sale Date and Pull Data

    Ashton Summers



      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,