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
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!
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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.