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.

Looking to display the last order date of a customer

Topic Labels: Formulas
1577 4
cancel
Showing results for 
Search instead for 
Did you mean: 
MacaulayGidado
4 - Data Explorer
4 - Data Explorer

My first table is a list of orders with a date and a customer name that is linked to the customer table I need to display the date of the last order on the customer table.

4 Replies 4
Kamille_Parks
16 - Uranus
16 - Uranus

Use a Rollup field with a MAX(values) aggregation.

MacaulayGidado
4 - Data Explorer
4 - Data Explorer

@Kamille_Parks how do I do that?

Go to your Customers table, make a Rollup field, select the orders Table, select the Order Date field, enter MAX(values) as the aggregation.

MacaulayGidado
4 - Data Explorer
4 - Data Explorer

@Kamille_Parks it returns 0 for all cells