calculation on pivot table

[hrwatkins86]

Spoiler

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

	Event Name	Items Received	Items Delivered
Timestamp 1	x	10	40
Timestamp 2	x	20
Timestamp 3	y	40	50

What I need is Line 1 & Line 2 added together for Items  Received, and divide that number by line 1 of items delivered.

How do I achieve this?

[Arthur_Tutt]

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:

 Table Setup:

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.

Let me know if that worked for you!!