I'm trying to calculate return rate (items received/ items delivered), but aggregate them by day. However, there are multiple receiving lines for each event, and only one input for items delivered. I'd normally do a formula based off a pivot table but I'm not sure how to do that in Airtable.
Here's an example of the table I have
What I need is Line 1 & Line 2 added together for Items Received, and divide that number by line 1 of items delivered.
Hey @hrwatkins86 do your event names have consistent and predictable names? I'd imagine you could just create a view that filters by todays date (or date you want to check) and filters based on the event names. Check this out:
Desired Output in New View - Sums of Items Received And Delivered:
Filter Conditions - note: use the 'add condition group' option at the bottom, to encapsulate both Events with an OR statement (Event 1 or Event 2)
Finally, add a grouping based on date to have Airtable sum the values.