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.