I want to make an employee cash flow and I need to constantly add extra working hours which are different for every employ. I then need to sum all the extra hours for each employee and add the bonus in another table where his base salary is.
Is there any way I can do this?
Hello Lucian,
In the employee table, you can add two Sum fields which (base salary and extra hrs *rate field) then Make another equation field to sum both.
Also if there are multiple records for each month then just add the condition sum current month values.
Regards,
Sunny Singla
ssingla1985@gmail.com
+919855089359
Thank you Sunny, but maybe I wasn’t very clear.
I have two objects :
object 1. a table where someone inputs todays extra hours for every employee
object 2. a table with all employees for the accountant to see his base salary plus the extra bonus (calculated with a formula - base salary divided by base number of hours + base salary/ hour multiplied by the sum of the extra hours each day
Hope I was more clear this time.
Hello Lucian,
Yes, first you can copy that extra hrs income to Employee object using equation(if 1-1 connection) or sum field.
Then use that Field value in Table 2 (salary table)
you can also mail me for any other professional help. I’m sure it can be doable.
Regards,
Sunny Singla
ssingla1985@gmail.com
+919855089359