Rollup of Linked records with filter

I’ve got a table that already has a link that is working. In this case it is Order Line Items to Products.

I’d like to have a column in my Products table that has the total of Order Line Items (line item total) within the past 60 days.

I could change the link to be filtered by a View, but then I’d not be able to see the Total Lifetime Orders.

How can I filter the linked records during Rollup?

Hi @Eric_Falsken - I would create another field to capture totals within the last 60 days:

the “last 60” field is a formula:

IF(DATETIME_DIFF(TODAY(), date, 'days') > 60, 0, {line item total})

Now you can rollup line item total for lifetime sales and “last 60” for sales within the last 60 days

JB

2 Likes