I have a form that contains various data relating to my clients ("Clients"), and another form with information pertaining to my team members ("Team Members"). I would like to manipulate this data in order to provide KPIs that I can easily reference.

There are three specific KPIs I have in mind at this time:

• Gross Income. This one's easy; it just needs to calculate the sum of the Gross Income field in Clients.
• Total Cost Per Word. This needs to add up the sums of Writer Cost and Editor Cost within Clients, and also the sum of Cost Per Month within Team Members, then divide the total sum by the sum of Monthly Word Count within Clients.
• Net Income. This needs to subtract all costs (i.e. Writer Cost, Editor Cost, and Cost Per Month) from Gross Income.

I'm not sure how best to do this (e.g. is it a new form, a report, etc.). Could someone please advise me?

Thanks!