I an creating an export that will send many records by date that we want to not only group but to sum and only send the total. Is that possilbe.
We have a custom that allows the user to enter timesheets for their employees and then export to a 3rd party payroll system. If we send in detail the employee would have a line for each day they entered hourly time on their paycheck
- 5/1/2023 8 hour
- 5/13/2023 8 hour
- 5/14/2023 8 hour; 2 OT
- 5/15/2023 8 hour
Would like the data exchange to send 40 hour; 2 OT
I have tried the grouping but that only seems to sort them together.
Any help would be appreciated.