Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Count All Values Excluding Most Recent on Roll Up Field

Topic Labels: Formulas
279 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi guys,

Got a base where I track my products inventory and need to use a Roll Up field on a table to know the actual amount of product left in the inventory.
I also need to know the amount of product before the last inventory movement to be able to know if the inventory came from" in stock" to “out of stock” or the opposite. This part of an automation process were I will send emails to people that were awaiting a product to come back in stock. The idea is to compare both inventory values and trigger the scenario only is the stock went from 0 to whatever value that is not zero.

So my need is to be able to sum all records for a specified product except from the last one. I would likely use the “created date” field but not operator allows us to target “the most recent” or “the last”.

Any idea on how to archive that goal ?

Thanks

0 Replies 0