Hi, Below is my airtable base.
I have grouped the records on basis of my product. I want to find the average of qty in each group. The average should be such that total of all qty in a group divided by no.of.rows in that group. How can i do this on Airtable?
For eg - THe average of first group is 68/8 = 8.5