Create Your Invoices Aggregate Formula

This goes a little bit beyond what is taught in the course and works with data from two different modules. We nest a conditional IF statement inside of a SUM (aggregate formula), only adding up the Invoice Item ‘Quantity’ if the Invoice Date was in the last 120 days.

Back to Lesson