Cumulative Line Chart for Sales Data - New Formula Query's

Hi everyone,

I had created a complicated snapshot table  linked to my invoices table to generate a cumulative line chart showing sales YTD compared to last year.  It works, although not perfect.

With the new formula queries I am thinking this would now be simpler in a much easier and faster way with less moving parts.  I have had several quick base updates break my original concept (including recently with the move to pipelines) so rebuilding in query functions seems like a good idea.

Just not sure where to start here....  Has anyone had any success in doing anything like this that might shed some light on it?  Here is the workflow for where the data comes from:

Our invoices table is attached to a project.  When a client approves a project our team creates records on the invoices table to "forecast" when we will bill.  Ultimately once they invoice the client (in Quick Books) we enter the invoice # and date on the base record.  That is how we know the invoice went out vs a projection.

So what I need is a running total of the cumulative invoices to date based on the quick books invoice date field in the current year.  So 2019, 2020, and 2021 would have running sets of data in the same year.  Projection invoices would not count since their invoice date is blank (null).

Thanks!​

------------------------------
Ivan Weiss
------------------------------