I am having trouble replicating a formula. It works in one document but now I am trying to use it in another and it is not working.
I have a customer table and an invoice table. The customer table has all my customers. The invoice table has all the invoices for 2019 to YTD. In the customer table, I want a field called “last order date” with the date of the most recent invoice for each customer. So Whole Foods might be 2/5/2020 and Store B is 11/25/19.
The formula in the existing doc is: AllInvoices.Filter (thisRow=Customer).InvoiceDate.Max()
When I replicate it in the new doc, I just have blanks.
Tables are set up the same and Customer is the primary field in both.