I have Data coming from Excel for Pay Roll.
How I need to take the data to the next step. Week 1 Reg. Hour and Over Time. Week 2 Reg. Hours worked and Over time. But don't know how to do it. I have been at it for some time know.
Hi @enocperez
Attached in the workflow which has the additional of the multi-row formula.
Best,
Jordan
I am not entirely sure how to arrive at the fields you have below with your sample data. Is it possible to send some sample data, as well as how to calculate Reg. HR & OT Hr. As well as what quantifies at week 1, week 2 etc.
I have attached a workflow which may demonstrate what you need, but additional information would be appreciated.
Jordan Barker
Solutions Consultant
Here is the HR Customer Sample Data and below is the flow that I have so far.
