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!!!