3 Replies Latest reply on Jan 20, 2019 2:42 AM by Diego Parker

    Lookup most recent event and return value

    William Merrill

      I have a table listing invoices for regions.  The issue stores within these regions change from time to time, and when I try do to YoY calculation at the region level, it returns zero for the prior year.  How can I find the most recent invoice and use that region number for all invoices?

       

      Thank you.