Rollup - Sum Last 7 Days Sales

[Matt_Lawry]

Hey Guys,

Pretty new to AirTable and struggling to work out how to achieve this.

I have 2 tables - product data-base and orders.

I created a Rollup field for the SUM of sales for each product variant (Variant ID). This worked great, but I don’t want to see total sales only the last 7 days sales. I.e. TODAY - 7. I’d like this to update dynamically each day

Is there a formula which will sum the last 7 day sales by variant from ‘Orders’ and feed this into ‘Product Database’?

Thanks!

[JonathanBowen]

Hi @Matt_Lawry - if you’ve got an orders table similar to this:

Add another column that shows the quantity sold if the order was in the last 7 days - the formula in my base is this:

IF(DATETIME_DIFF(NOW(), Date, 'days') > 7, 0, Quantity)

Now, back in your product table you can roll-up this field:

Hope this helps.

JB