I'm uploading invoices into our table. Each entry in the table will list the date run, the company name, qty and subtotal. I also want to add a column that populates what the previous month's qty was, so i can add an additional column that calculates the variance.
Can someone help me with what the formula would be to return the previous month's qty?
Thanks in advance
Noelle shared this idea · Dec 6, 2018