Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Set Conditional Rollup to match a field value

Topic Labels: Base design
Solved
Jump to Solution
2274 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Keith_McFarland
4 - Data Explorer
4 - Data Explorer

I’m rolling up a list of quantities, and need to determine which quantity was the most recently ordered. I have a separate Rollup field on the same table identifying the most recent date, but I need to be able to set the value of the filter on quantity rollup to only show the quantity when the production date matches the date I have in the second rollup field.

Is there a way to set the value of a filter to match a field value?

Cheers,
AK

1 Solution

Accepted Solutions
Databaser
12 - Earth
12 - Earth

Hi @Keith_McFarland and welcome to the community!

The solution I tend to use is to rollup your dates via the linked field to your first table with quantities, and add a lookup field to your first table, looking up that most recent date via the linked field. Then add a formula field that checks if the most recent date is equal to the date of the quantity:

IF({Date Rollup (from quantities) (from rolling up)}=Date,“most recent”)

Then go back to table 2 and rollup the quantities conditionally with “where ‘most recent’ contains ‘most recent’” and use the "SUM(values) to add those quantities.

Table 1: quantities
image

Table 2
image

Does that helps you?

See Solution in Thread

2 Replies 2
Databaser
12 - Earth
12 - Earth

Hi @Keith_McFarland and welcome to the community!

The solution I tend to use is to rollup your dates via the linked field to your first table with quantities, and add a lookup field to your first table, looking up that most recent date via the linked field. Then add a formula field that checks if the most recent date is equal to the date of the quantity:

IF({Date Rollup (from quantities) (from rolling up)}=Date,“most recent”)

Then go back to table 2 and rollup the quantities conditionally with “where ‘most recent’ contains ‘most recent’” and use the "SUM(values) to add those quantities.

Table 1: quantities
image

Table 2
image

Does that helps you?

I missed the step of passing the date back to the original table to perform the match. Brilliant!

Thanks for your help, this solved my issue!