Creating an Average Formula

Topic Labels: Formulas
972 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

After solving an earlier query about setting my formula and linking a client and rates table I now need to create a column which averages out my earnings from clients. Should this be in my clients table or do I need to create a separate table for this?

I now have records with the numbers of sessions for each client and total earnings for each client - all in my clients table - so where and how should my average income per client calculation go please?

Thanks in advance


2 Replies 2
10 - Mercury
10 - Mercury

Create another field on the [Clients] table, with a formula like…

{Total Earnings}/{Number of Sessions}

Then, set the formatting to be a currency.

If you want to get the average earned for ALL of your clients/sessions, you can either use the summary bars at the top and bottom of your grid view on the [Clients] table (also seen at the top of each group in a grid view), or you can set up a summary table and use rollups to get the average earnings per session. Happy to explain further if you’d like!

That is great. Thanks for your help. Will explore now I am getting to grips with Airtable. Think I will set up a summary table with roll ups.