Creating Employee Pay/Timesheet

[esforim]

Currently I have a bare minimum version and planning to add the https://docs.espocrm.com/administrat...titysumrelated
to it but I'm trouble on how to do it properly. Anyone add these feature to their EspoCRM yet and can share some insight? How did you do it?

Here how the basic version I got it as:
Gross Pay = $100
Tax Pay = $10
Net Pay = $90

---The issue is here: we require to have a "Year to Date" calculation as well, which let say after Week 5 it would look like this.

	This Week (5)	Year to Date (at week 5)
Gross Pay	$100	$500
Tax Pay	$10	$50
Net Pay	$90	$450

---
If I use the sumrelated it will always show $500 figure even if I were to print out Week 4 which should look like this but it doesn't because "sumrelated" will show all of it.

	This Week (4)	Year to Date (at week 4)
Gross Pay	$100	$400
Tax Pay	$10	$40
Net Pay	$90	$410

Looking forward to some input.

Some tag: payslip paystub payroll salary slip paycheck employee

[eymen-elkum]

You may need to develop custom [FILTER] and pass it to the frmula function

[esforim]

That a good idea, alternatively maybe I can use some date formula when I use the sumrelated.

Thank you.