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

Creating an Average Formula

Topic Labels: Formulas
727 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Liz

2 Replies 2

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.