Creating a Duplicate Row

[HULK]

Hello All,

I have attached how my input will be and how my output should be, please can you help me with creating a workflow.

I need to create a duplicate line item with all details being same in above rows / columns, the only change which is happening is in the amount (B7) cell (highlighted in pink in output tab of the attached). Amount is nothing but the sum of amount from column (B2:B6) including the signage (-). I want the difference of amount with negative sign to be reflected in amount column (B7) of the new line item generated (Row 7 of output) so that the total of amount should be equal to ZERO (summation of entire amount column should be ZERO).

Thanks

[IraWatt]

Hey @HULK,

This is how I would do this:

I group by on Acc and re join on Acc so this solution should work with multiple accounts.

Any questions or issues please ask :)
HTH!
Ira

[binuacs]

@HULK Another way of doing this