I am new to Coda and am getting desperate with a task:
I would like to preview my expenses by taking an average of all the individual expenses from previous months (e.g. salary transfers).
My data base looks like this: I have a table for each accounting month from January to April with categories (e.g. personnel) and below that the costs (e.g. salary transfers) and the amounts.
What kind of formula do I need to add up all the salary transfers from January to April and take an average of them? I would then need to apply this formula to all costs (about 20). Is it possible to display all this in a new table?
I am grateful for any tips!