Creating multiple rows in the same column depending on the condition

Hi I'm trying to create a column Type based on the condition like if the employee is working for Day then there should be a row named days in column type and if the same employee is doing overtime as well we need another row with hours in the same type column and the overtime hours need to be summed and updated in the hours column. could anyone please help me on how do i move forward with this . Attaching an example input and output. Thank you

INPUT

OUTPUT

Workflow

Accepted answers

All comments

RolandSchubert

Hi @nkrupabd ,

if I got you right, you need an additional column [Type], that has to be calculated depending on the [Overtime] column (if [Overtime] > 0 -> hours, else days).
Then you have to aggregate by Employee and Type, but aggregation seems to be only applied to overtime, not to day shift.

I've created a sample workflow, let me know if it works as expected.

Best,

Roland

TypeColumn.yxmd

nkrupabd

Thank you for the response, i just gave an example there are many such conditions which need to be applied and have to be used as each row for each condition in the same column.

IN the example i mentioned the column is TYPE and need rows of the column with days and hours , for same employee there need to be different rows depending on the condition.

RolandSchubert

That would lead to a more complex condition (or nested conditions), but it should be no problem using a formula. Could you provide more details or sample data?