I have an employees table where I input the daily value for each, among other values…
how can I get the monthly value for each and use it in another table, to make calculations?
Hello @ri6as, you can add a formula field to calculate the monthly value for each employee and then look up these values in another table using a link to table field.
Here’s an example:
Table 1:
Table 2:
Is this what you’re trying to achieve?
hi, thanks for your help!!
not exactly, in your example we have the values inserted by columns, in my case I have a line for each day/employee, so, i’ll have 30 lines for each employee (12 employees) - these are the values I want as total to use in other table/calculations!
Can this be done?
Hey @ri6as, that won’t be possible because the formula field works on a row level.
With the footer aggregations that work on a field level, you can perform simple calculations like average, sum, etc. but it’s not a good solution for your case because you can’t reference these values in another table.
If you restructure your data a bit, you could use the formula field, which will do exactly what you need.
hi,
can you point me in the right direction or show an example?
thanks
Hey @ri6as, we have a great article with useful tips on data modeling. Check it out: How to model your Baserow data.
To make the formula field work for you, consider following this structure:
But I don’t know the whole logic behind the work you do, it’s hard to point you on the right direction. 
hope I’m not pushing you too much… 
I have a table SALARY:
Employee_name / Date /Job / hours_worked / Hour_rate / Daily_Value
AA / c / A / 8 / 15 / 120€
BB / c / B / 8 / 14 / 112€
would like to create a table:
JOBS:
Job / Overall_Value
A / XXXX
B / YYYY
XXXX will be the aggregate value of all Employees on the Job A
YYYY will be the aggregate value of all Employees on the Job B
Would be good to have this value any time I’d need…
thanks again for your help!!!